include "/home/directev/www/mysql.inc";
include "domaine.inc";
$cat="97";
$scat = mysql_query("select id, nom from categorie where pere=$cat order by nom");
$sites = mysql_query("select * from sites s, link l where (s.id=l.obj_id and l.cat_id=$cat) order by nom");
$tot = mysql_query("select count(*) as tot from sites s, link l where (l.obj_id=s.id and l.cat_id = $cat)") ;
$i=0;
while ($row = mysql_fetch_array($sites)) {
$tot2 = mysql_query("select count(*) as tot2 from comment WHERE id = $row[id]") ;
$tot3 = mysql_result($tot2,0,tot2);
$bg="";
$bg1="#652365";
$bg2="#852E85";
if (($i % 2 ) ==0) {$bg='bgcolor="' . $bg2 . '"';}
else {$bg='bgcolor="' . $bg1 . '"';}
echo "";
echo "";
echo " | ";
echo " $row[nom] | ";
echo "";
echo " ";
echo " | ";
echo " ";
echo "";
echo "| $row[descr] | ";
echo " ";
echo " ";
echo " ";
$i++;
}
?>
|