hum, oui, j'ai été un peut trop vite aussi ^^ Tu dois remettre tes conditions de recherche dans la requête pour compter.
// Données de pagination
$perPage = 4;
$cPage = 1 ;
// Requêtes pour le moteur de recherche
$query = "SELECT * FROM annonce
LEFT JOIN type_annonce ON annonce.type_annonce = type_annonce.id
LEFT JOIN type_annonceur ON annonce.vous_etes = type_annonceur.id
LEFT JOIN categorie ON annonce.id_categorie = categorie.id
LEFT JOIN villes ON annonce.id_ville = villes.id
LEFT JOIN departement ON villes.departement = departement.code
LEFT JOIN region ON departement.id_region = region.id_region
WHERE activer_annonce=1";
$query_count = "SELECT count(id) AS count FROM annonce
LEFT JOIN type_annonce ON annonce.type_annonce = type_annonce.id
LEFT JOIN type_annonceur ON annonce.vous_etes = type_annonceur.id
LEFT JOIN categorie ON annonce.id_categorie = categorie.id
LEFT JOIN villes ON annonce.id_ville = villes.id
LEFT JOIN departement ON villes.departement = departement.code
LEFT JOIN region ON departement.id_region = region.id_region
WHERE activer_annonce=1";
// Ajout des conditions de requêtes
$f=explode(',', $_GET'area']);
foreach($f as $fe)
if (isset($_GET'area']) != "") {
$query .= " AND region.id_region LIKE '%$fe%'";
$query_count .= " AND region.id_region LIKE '%$fe%'";
}
$q=explode(',', $_GET'dep']);
foreach($q as $depart)
if (isset($_GET'area']) != "") {
$query .= " AND code LIKE '%$depart%'";
$query_count .= " AND code LIKE '%$depart%'";
}
$s=explode(" ",$t);
foreach($s as $mot)
if ($mot != "") {
$query .= " and titre_annonce LIKE '%$mot%' ";
$query_count .= " and titre_annonce LIKE '%$mot%' ";
}
if (isset($_GET'a']) != "") {
$query .= " AND vous_etes LIKE '%$a%'";
$query_count .= " AND vous_etes LIKE '%$a%'";
}
$z=explode(" ",$c);
foreach($z as $all)
if (isset($_GET'c']) != "") {
$query .= " AND id_categorie LIKE '%$c%'";
$query_count .= AND id_categorie LIKE '%$c%'";
}
$e=explode(" ",$cp);
foreach($e as $code_postal)
if (isset($_GET'cp']) != "") {
$query .= " AND villes.code_postal LIKE '%$code_postal'";
$query_count .= " AND villes.code_postal LIKE '%$code_postal'";
}
if (isset($_GET'offres']) != "") {
$query .= " AND type_annonce LIKE '$type'";
$query_count .= " AND type_annonce LIKE '$type'";
}
// Ajout des conditions de pagination
$query .= " ORDER BY id_annonce DESC LIMIT ".(($cPage-1)/$perPage)." ,$perPage";
// Exécution des requêtes
$result1 = mysql_query($query, $cnx);
$nb_result1 = mysql_query($query_count, $cnx);
$nbPage = ceil($nb_result1'count']/$perPage);
echo $nbPage;