|
|||||||||||
المحاضرات العموميةrequire "../../replace.php"; require "../../../connection.php"; //require "/home/academie/connection.php"; $vide=""; //echo "select distinct YEAR(date) from conferences where pdf <> $vide order by date desc"; $requete_0= "select distinct YEAR(date) from conferences where pdf <> '' order by date desc"; $resultat_0=mysql_query($requete_0) or die ('ca ne marche pas ici') ; $k=1; while($row_0=mysql_fetch_row($resultat_0)){ $vide=""; $requete= "select * from conferences where annee = $row_0[0] and pdf IS NOT NULL order by date"; $resultat=mysql_query($requete) or die ('ca ne marche pas') ; $nac=mysql_fetch_row($resultat) or die ("probleme laba"); ?>عام echo $nac[1]; ?>
//echo "select * from conferences where annee = $nac[1] and pdf <> '' order by date";
$requete3= "select * from conferences where annee = $nac[1] and pdf <> '' order by date";
$resultat3=mysql_query($requete3) or die ('ca ne marche pas') ;
while($row=mysql_fetch_row($resultat3)){
$numero=$row[0];
$annee=$row[1];
$auteur=$row[2];
$titre=$row[3];
$date=$row[4];
$pdf=$row[5];
$video=$row[6];
$audio=$row[7];
$nom=$row[8];
?>
|