$sc=8;
if(isset($_GET["sc"]))$sc=$_GET["sc"];
?>
$i=1;
$res=mysql_query("SELECT new_sujet$lang, new_corps$lang,new_id FROM news WHERE new_fk_sca=$sc AND new_online='oui';",$id_connexion);
while($row=mysql_fetch_row($res)){
echo "

";
echo "
";
$res2=mysql_query("SELECT ima_path FROM images WHERE ima_fk_news='$row[2]';",$id_connexion) or die(mysql_error());
if(mysql_num_rows($res2)>0){
if($i%2==0){
echo "
$row[1] | ";
while($row2=mysql_fetch_row($res2)){
echo "
";
}
echo " |
";
}else{
echo "
";
while($row2=mysql_fetch_row($res2)){
echo "
";
}
echo " | $row[1] |
";
}
}else{
echo "$row[1]";
}
$i++;
}
?>