By topic :
$cat = mysql_fetch_array(mysql_query("SELECT NomAN FROM Traducteur_categ WHERE Code=\"$code\""));
$num = Compte_mot_categ($code,1);
if($num>0) {
echo ''.$cat["NomAN"].'';
if($num>1) $s="s";
echo " ($num word$s)";
} else echo '
'.$cat["NomAN"].'';
echo '
';
$cat2 = mysql_query("SELECT * FROM Traducteur_categ WHERE Code like '".substr($code,0,1)."_0' AND Code NOT like '$code' ORDER BY Code");
while($c2 = mysql_fetch_array($cat2)) {
// ############ Ecrit la ligne 2
$num = Compte_mot_categ($c2["Code"],2);
if($num>0) {
echo ' - '.$c2["NomAN"].'';
if($num>1) $s="s";
echo " ($num word$s)";
} else echo ' - '.$c2["NomAN"];
echo '
';
$r3 = 'SELECT * FROM Traducteur_categ WHERE Code like "'.substr($c2["Code"],0,2).'_" AND Code NOT like "'.$c2["Code"].'" ORDER BY Code';
$cat3 = mysql_query($r3);
while($c3 = mysql_fetch_array($cat3)) {
// ############ Ecrit la ligne 3
$num = Compte_mot_categ($c3["Code"],3);
if($num>0) {
echo ' - '.$c3["NomAN"].'';
if($num>1) $s="s";
echo " ($num word$s)";
} else echo ' - '.$c3["NomAN"];
echo '
';
}
}
?>