Forum d'entraide PHPFrance

Bonjour,

j'ai fait un menu total en php. Mais je l'ai fait avec 2 requetes. Puis-je le faire en une seule??

<?
$sql = " SELECT cat_cle, cat_lib FROM categorie WHERE cat_cle < 8 ORDER BY cat_lib DESC ";
$qry = pg_query($conn, $sql);
while ($result = pg_fetch_assoc($qry))
{
?>
<tr>
<td align="left" id="menu">								<?=$result['cat_lib']?><br>
</td>
</tr>
<?
$sql2 = " SELECT doc_cle, doc_lib, doc_type, doc_file, doc_cat FROM documents WHERE doc_cat=".$result['cat_cle']." ORDER BY doc_lib DESC ";
$qry2 = pg_query($conn, $sql2);
while ($result2 = pg_fetch_assoc($qry2))
{
$clefile = $result2['doc_file'];
?>
<tr>
<td align="left" id="menu">
&nbsp;&nbsp;&nbsp;<a href="../admin/file.php?cle=<?=$result2['doc_cle']?>&oid=<?=$clefile?>&doc_type=<?=$result2['doc_type']?>" target="bodemer"><?=$result2['doc_lib']?></a><br>
</td>
</tr>
<?
}
}
?>

tu pourrai en utilisant un GROUP BY.

$Requete="
SELECT cat_cle, cat_lib, doc_cle, doc_lib, doc_type, doc_file, doc_cat 
FROM categorie, documents  
WHERE cat_cle < 8 AND cat_cle=doc_cat 
ORDER BY cat_lib DESC,doc_lib DESC
GROUP BY cat_cle"

A verfié.