'.$sqli.'
'.mysql_error()); echo ''; die(); } while($res = mysql_fetch_array($resultati)) { $cat = $res['id']; } /*print_r($objecti); echo "****"; echo $cat; $cat = $objecti->id;*/ //echo '='.$cat.'='; } else{ $cat = $_GET[cat]; } $sql3 = "SELECT * FROM galery_cat WHERE id=$cat"; if(!$resultat3 = mysql_query($sql3)) { // or die('Erreur SQL !
'.$sql3.'
'.mysql_error()); echo ''; die(); } $objet3 = mysql_fetch_object($resultat3); $nom_cat = $objet3->nom_cat; $nom_cat = str_replace("[BBB]","'",$nom_cat); $nom_cat = str_replace("[AAA]",""",$nom_cat); $nom_cat = str_replace("[VVV]",",",$nom_cat); $nom_cat = str_replace("[BR]","
",$nom_cat); $sql = "SELECT * FROM galery_cat ORDER BY id ASC"; if(!$resultat = mysql_query($sql)) { // or die('Erreur SQL !
'.$sql.'
'.mysql_error()); echo ''; die(); } echo "

"; echo "
    "; while($objet = mysql_fetch_object($resultat)) { $sql_4 = "SELECT * FROM gallery WHERE categorie = $objet->id"; // echo $sql_4; if(!$resultat_4 = mysql_query($sql_4)) { // or die('Erreur SQL !
    '.$sql_4.'
    '.mysql_error()); echo ''; die(); } $tab_4 = mysql_fetch_array($resultat_4); $nom_cate = stripslashes($objet->nom_cat); $nom_cate = str_replace("[BBB]","’",$nom_cate); $nom_cate = str_replace("[AAA]",""",$nom_cate); $nom_cate = str_replace("[VVV]",",",$nom_cate); $nom_cate = str_replace("[BR]","
    ",$nom_cate); //echo mysql_num_rows($resultat_4); if(mysql_num_rows($resultat_4) != 0){ echo "
  • id\">$nom_cate
    • "; } else { echo "
  • $nom_cate
    • "; } } echo "
"; ?>




'.$sql2.'
'.mysql_error()); echo ''; die(); } $objet2 = mysql_fetch_object($resultat2); echo ""; } else { echo "
nom_fichier\" alt=\"\" style=\"border:1px solid #3869B5;margin-left:7px;margin-right:7px;margin-top:27px;\" />
$nom_cat

"; $sql1 = "SELECT * FROM gallery WHERE categorie=$cat ORDER BY numero_diapo"; if(!$resultat1 = mysql_query($sql1)) { echo ''; die(); } while($objet1 = mysql_fetch_object($resultat1)) { $j = $j+1; echo "numero_diapo\">nom_fichier\" style=\"margin:2px;\"/>"; if($j==5) { echo "
"; $j=0; } } echo "
"; } if(isSet($_GET['img'])) { $sql2 = "SELECT * FROM gallery WHERE categorie=$cat AND numero_diapo=$img"; if(!$resultat2 = mysql_query($sql2)) { // or die('Erreur SQL !
'.$sql2.'
'.mysql_error()); echo ''; die(); } $objet2 = mysql_fetch_object($resultat2); $sql45 = "SELECT MAX(numero_diapo) AS maax FROM gallery WHERE categorie=$cat"; if(!$resultat45 = mysql_query($sql45)) { // or die('Erreur SQL !
'.$sql45.'
'.mysql_error()); echo ''; die(); } $objet45 = mysql_fetch_object($resultat45); $maxi = $objet45->maax; if($_GET['img'] == 0) { $img_prec = $maxi; $catprec = $cat - 1; $catsuiv = $cat; if($catprec == 0) { $catprec=12; } } else { $img_prec = $_GET['img'] - 1; $catprec = $cat; $catsuiv = $cat; } if($_GET['img'] == $maxi) { $img_suiv = 0; $catsuiv = $cat+1; if($catsuiv == 13) { $catsuiv=1; } } else { $img_suiv = $_GET['img'] + 1; $catsuiv = $cat; } $leg1 = str_replace("[BBB]","'",$objet2->legende_1); $leg1 = str_replace("[AAA]",""",$leg1); $leg1 = str_replace("[VVV]",",",$leg1); $leg1 = str_replace("[BR]","
",$leg1); $leg2 = str_replace("[BBB]","'",$objet2->legende_2); $leg2 = str_replace("[AAA]",""",$leg2); $leg2 = str_replace("[VVV]",",",$leg2); $leg2 = str_replace("[BR]","
",$leg2); echo "

$nom_cat

$leg1

$leg2


"; echo "

"; echo " < Précédent"; echo "Suivant >

"; } ?>