include("conelo.php") ;
//affiche ville
echo "
";
echo "".urldecode(stripslashes($_GET['ville']))." |
";
echo "
";
echo "
";
echo "".stripslashes($_GET['n'])." |
";
$sql="select * from voir where id='".$_GET['vu']."'";
$result = mysql_db_query($db, $sql);
$res=mysql_fetch_array($result);
$num=mysql_num_rows($result);
echo "
";
echo "".stripslashes($res['cat'])." |
";
echo "
";
echo "
";
echo "".nl2br($res['description'])." |
";
echo "
";
unset($sql); unset($num); unset($res); unset($result);
$sql="select * from descriptif where ref_id='".$_GET['vu']."' and table1= 'V' order by ordre asc";
$result = mysql_db_query($db, $sql);
$num=mysql_num_rows($result);
if($num>0){
while ($res=mysql_fetch_array($result)){
if($res['biblio']!=""){
//echo "
";
echo "".$res['biblio']."
";
}
//teste sur photo
if($res['photo']!=""){
//extraire les photos
$ph=explode(",",$res['photo']);
//afficher les photos
//echo "";
for ($i=0;$i";
$nph=explode(".",trim($ph[$i]));
$nph0=$nph[0];
$lg=strlen($nph0);
$nw=substr($nph0,0,$lg-2);
$nw=$nw."GD.".$nph[1];
//echo "."\") | ";
echo "
";
}
//echo "
";
}
//echo "";
echo "".nl2br($res['description'])."
";
echo "
";
//echo "
" ;
//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='D' and ref_id='".$res['id']."' order by cat";
$result2 = mysql_db_query($db, $sql2);
$categ="";
//echo "
";
while ($r=mysql_fetch_array($result2)){
///////////////////////////////////
if($categ=="" || $categ!=$r['cat']){
$categ=$r['cat'];
if($categ=="Imprimé") {
echo " Bibliographie ";
}
else {
echo "webographie ";
}
}
if($r['cat']=="internet"){
echo " ".$r['nom']."";
}
else {
echo " ".$r['nom']."";
}
$categ=$r['cat'];
////////////////////////////////////
}
//echo " |
";
echo "
";
}
}
echo "";
?>
|