1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
<?php
$menu_jdr=mysql_query("SELECT * FROM categorie_jdr ORDER BY nom");
while($message = mysql_fetch_assoc($menu_jdr)) {
echo "
<li class='menu_head'>$message[nom]</li>
<ul class='menu_body' id='$message[id]'>";
$vrace=mysql_num_rows(MYSQL_QUERY("select id from race where id_jdr=$message[id]"));
$vclasse=mysql_num_rows(MYSQL_QUERY("select id from classe where id_jdr=$message[id]"));
$vprof=mysql_num_rows(MYSQL_QUERY("select id from profession where id_jdr=$message[id]"));
$vmag=mysql_num_rows(MYSQL_QUERY("select id from sort where id_jdr=$message[id]"));
$vmonstre=mysql_num_rows(MYSQL_QUERY("select id from monstre where id_jdr=$message[id]"));
if ($vrace==0) { echo"<li><a href='race.php?jdr=$message[id]'>Race</a></li>"; }
if ($vclasse==0) { echo"<li><a href='classe.php?jdr=$message[id]'>Classe</a></li>"; }
if ($vprof==0) { echo"<li><a href='profession.php?jdr=$message[id]'>Profession</a></li>"; }
if ($vmag==0) { echo"<li><a href='magie.php?jdr=$message[id]'>Magie</a></li>"; }
if ($vmonstre==0) { echo"<li><a href='monstre.php?jdr=$message[id]'>Monstre</a></li>"; }
echo "</ul>";
}
?> |