$rq="select c.*,d.num, d.preposition from club c INNER JOIN departements d ON d.id=c.id_dept where c.valide = 1 ORDER BY c.id desc LIMIT 0,7";
$result=mysql_query($rq) or die(mysql_error());
$i=0;
while($rs=mysql_fetch_array($result)){
//$style =($i%2 == 0)? "list_colone" : "list_colone2";
?>
$rq="Select l.*, c.nom ,d.num, d.preposition FROM club_avis l INNER JOIN club c ON c.id= l.id_club INNER JOIN departements d ON d.id=c.id_dept WHERE l.valide=1 ORDER BY l.id_avis DESC LIMIT 0,8";
$result=mysql_query($rq) or die(mysql_error());
$i=0;
while($rs=mysql_fetch_array($result)){
//$style =($i%2 == 0)? "list_colone" : "list_colone2";
?>