1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| $requete="select distinct rubrique from tabletest order by rubrique asc";
$exe=mysql_query($requete);
if($exe)
{
while($lis=mysql_fetch_array($exe,MYSQL_ASSOC))
{
echo '<br>.....'.$lis[rubrique];
$requete="select theme from tabletest where rubrique = '".$lis[rubrique]."' order by theme asc";
$exec=mysql_query($requete);
if($exec)
{
while($list=mysql_fetch_array($exec,MYSQL_ASSOC))
{
echo '<br>.....'.$list[theme];
$requete="select nom from tabletest where rubrique = '".$lis[rubrique]."' and theme='".$list[theme]."' order by nom asc";
$exes=mysql_query($requete);
if($exes)
{
while($liste=mysql_fetch_array($exes,MYSQL_ASSOC))
{
echo '<br>...........'.$liste[nom];
}
}
}
}
}
} |