| Nombre | Ingles | Euskera |
|---|
\n";
while ($r = mysqli_fetch_array($q)){
echo "
| $r[title_es] | ";
$total = 1; //Title is mandatory
$translated_en = 0;
$translated_eu = 0;
//Calculate field number
if ($r['title_en'] != $r['title_es']){
$translated_en ++;
}
if ($r['title_eu'] != $r['title_es']){
$translated_eu ++;
}
if (strlen($r['description_es']) > 0){
if ($r['description_en'] != $r['description_es']){
$translated_en ++;
}
if ($r['description_eu'] != $r['description_es']){
$translated_eu ++;
}
}
$q_i = mysqli_query($con, "SELECT title_es, title_en, title_eu, description_es, description_en, description_eu FROM photo, photo_album where photo = id AND album = $r[id]");
while ($r_i = mysqli_fetch_array($q_i)){
$total ++;
if ($r_i['title_en'] != $r_i['title_es']){
$translated_en ++;
}
if ($r_i['title_eu'] != $r_i['title_es']){
$translated_eu ++;
}
if (strlen($r_i['description_es']) > 0){
$total ++;
if ($r_i['description_en'] != $r_i['description_es']){
$translated_en ++;
}
if ($r_i['description_eu'] != $r_i['description_es']){
$translated_eu ++;
}
}
}
//Calculate percents
echo "" . intval($translated_en * 100 / $total) . "% | " . intval($translated_eu * 100 / $total) . "% |
\n";
}
echo "\n";
?>