1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| $coldept_rs_annonce = "0";
if (isset($_GET['dept'])) {
$coldept_rs_annonce = $_GET['dept'];
}
$colnomcat_rs_annonce = "0";
if (isset($_GET['cat'])) {
$colnomcat_rs_annonce = $_GET['cat'];
}
$colcp_rs_annonce = "0";
if (isset($_GET['cp'])) {
$colcp_rs_annonce = $_GET['cp'];
}
mysql_select_db($database_annuaire, $annuaire);
$query_rs_annonce = sprintf("SELECT * FROM an_annonce WHERE (dept=%s AND nomcat=%s AND cp=%s", GetSQLValueString($coldept_rs_annonce, "text"),GetSQLValueString($colnomcat_rs_annonce, "text"),GetSQLValueString($colcp_rs_annonce, "int"));
$query_limit_rs_annonce = sprintf("%s LIMIT %d, %d", $query_rs_annonce, $startRow_rs_annonce, $maxRows_rs_annonce);
$rs_annonce = mysql_query($query_limit_rs_annonce, $annuaire) or die(mysql_error());
$row_rs_annonce = mysql_fetch_assoc($rs_annonce); |
Partager