nb_cat; $nb_col_cat = ceil($nb / $nb_limite); $i = 0; while($i<$nb_col_cat) { $deb_cat = $i*$nb_limite; //$requete_cat = "SELECT * FROM categorie ORDER BY libelle_categorie LIMIT $deb_cat,$nb_limite"; //$result_cat= mysql_query($requete_cat, $con); $requete_cat = "SELECT c.*, COUNT(pc.id_prod_cat) AS nb_prod_cat FROM categorie c LEFT JOIN prod_cat pc ON pc.id_categorie = c.id_categorie GROUP BY c.id_categorie ORDER BY c.libelle_categorie LIMIT $deb_cat,$nb_limite"; $result_cat= mysql_query($requete_cat, $con); ?>
nb_client; $nb_col_client = ceil($nb2 / $nb_limite); $j = 0; while($j<$nb_col_client) { $deb_client = $j*$nb_limite; //$requete_client = "SELECT * FROM client ORDER BY nom_client LIMIT $deb_client,$nb_limite"; //$result_client= mysql_query($requete_client, $con); $requete_client ="SELECT c.*, COUNT(pc.id_prod_client) AS nb_prod FROM client c LEFT JOIN prod_client pc ON pc.id_client = c.id_client GROUP BY c.id_client ORDER BY c.nom_client LIMIT $deb_client,$nb_limite"; $result_client= mysql_query($requete_client, $con); ?>
    id_client"; //$res_nb_par_client= mysql_query($req_nb_par_client, $con); //$nb_prod_client = mysql_num_rows($res_nb_par_client); ?>
  • 0) if($db_client->nb_prod > 0) { ?> 0) if($db_client->nb_prod > 0) { ?>

libelle_categorie); echo $db_titre->libelle_categorie_maj; } if(isset($id_client)) { $req_c = "SELECT * FROM client WHERE id_client = '$id_client'"; $res_c = mysql_query($req_c, $con); $db_c = mysql_fetch_object($res_c); echo $db_c->nom_client_maj; $req_client = "SELECT n.* FROM client c, nationalite n, client_nat cn WHERE c.id_client = '$id_client' AND c.id_client=cn.id_client AND cn.id_nationalite = n.id_nationalite "; //echo $req_client; $res_client = mysql_query($req_client, $con); //$db_client = mysql_fetch_object($res_client); while($db_client = mysql_fetch_object($res_client)) { //echo "test"; //echo strtoupper($db_client->nom_client); //echo "drapeau :".$db_client->drapeau."
"; if($db_client->drapeau != "") { ?> nom_nation; } } } ?>

nb_res." produit"; if($db_nb_res->nb_res > 1) { echo "s"; } } if(isset($id_client)) { $req_nb_res = "SELECT COUNT(*) as nb_res FROM prod_client WHERE id_client = '$id_client'"; $res_nb_res = mysql_query($req_nb_res, $con); $db_nb_res = mysql_fetch_object($res_nb_res); echo $db_nb_res->nb_res." produit"; if($db_nb_res->nb_res > 1) { echo "s"; } } ?>
*/ ?>
"; $res_affiche_resultat = mysql_query($req_affiche_resultat, $con); while($db_affiche_resultat = mysql_fetch_object($res_affiche_resultat)) { ?>
photo1 != "") {?>style="background-image:url(upload/photo/)"> photo1 != "") { if($db_affiche_resultat->zoom != "") { ?> zoom != "") { ?> zoom != "") { ?>

nom_client_maj." "; $req_affiche_resultat2 = "SELECT n.* FROM client c, nationalite n, client_nat cn WHERE c.id_client = '$db_affiche_resultat->id_client' AND c.id_client=cn.id_client AND cn.id_nationalite = n.id_nationalite "; $res_affiche_resultat2 = mysql_query($req_affiche_resultat2, $con); while($db_affiche_resultat2 = mysql_fetch_object($res_affiche_resultat2)) { if($db_affiche_resultat2->drapeau != "") { ?> nom_nation; } } ?>

libelle_produit); echo stripslashes($db_affiche_resultat->libelle_produit_maj); } ?>

id_produit' AND pc.id_categorie = c.id_categorie"; $res_cat_prod = mysql_query($req_cat_prod, $con); ?>
libelle_categorie."
"; } ?>