include("conelo.php") ;
//affiche ville
echo "
".stripslashes($_GET['ville'])." "; echo " ".$_GET['n']." "; $sql="select * from descr_lien where ref_id='".$_GET['vu']."' order by ordre asc"; $result = mysql_db_query($db, $sql); $num=mysql_num_rows($result); if($num>0){ while ($res=mysql_fetch_array($result)){ echo " ".$res['Titre']." "; // if($res['biblio']!=""){ //echo "
".$res['biblio']." "; //teste sur photo if($res['photo']!=""){ //extraire les photos $ph=explode(",",$res['photo']); //afficher les photos //echo ""; } // } // echo "
".nl2br($res['description'])." "; //bilbliographie // $sql2="select ref_biblio from biblio_corr where table2='D' and ref_id='".$res['id']."'"; $sql2="select ref_biblio,biblio.nom,biblio.cat from biblio_corr left join biblio on biblio.id=biblio_corr.ref_biblio where table2='DL' and ref_id='".$res['id']."' order by cat"; $result2 = mysql_db_query($db, $sql2); $categ=""; //echo "
"; } } echo "
|