$rqwall="SELECT * FROM wall WHERE type='$wall' ORDER BY no DESC";
$reswall=mysql_query($rqwall);
while ($lignewall=mysql_fetch_array($reswall))
{
echo " \n | \n";
echo " \n";
echo " 800*600|1024*768\n";
echo "
| \n \n";
$texte=nl2br($lignewall[comment]);
echo " $texte \n";
echo " | \n \n";
}
?>
|
|

|
|
$rq="SELECT wc.nomcat,w.type,COUNT(w.type)
FROM wall w,wallcat wc
WHERE w.type=wc.typecat
GROUP BY w.type
ORDER BY wc.nomcat";
$res=mysql_query($rq);
print(" ");
while ($ligne=mysql_fetch_array($res))
print(" [$ligne[0] <$ligne[2]>] \n");
?>
|
|

|
|