geht nicht, da "0" sonst als NULL interpretiert wird { $SEARCH_SQL .= " AND left(postalcode,1) ='".$plzID."'"; $PAGING_QUERY .= "&p=".$plzID; } // Anzeigen des Magazins laden /* $SQL = "select SQL_CALC_FOUND_ROWS a.id, a.advert_category_id, c.name AS category, a.advert_type, a.advert_picture, a.advert_header , a.advert_text , a.postalcode FROM advert AS a INNER JOIN category AS c ON a.advert_category_id = c.id WHERE advert_magazin_id = '".$magazin->id."' AND a.advert_start_date <='".$DatumHeute."' AND a.advert_end_date >='".$DatumHeute."' AND a.aktiv='1' ".$SEARCH_SQL." ORDER BY id DESC LIMIT ".(($CURRENT_PAGE-1)*$MAX_DATA_PER_PAGE).",".$MAX_DATA_PER_PAGE; $SQL = "select SQL_CALC_FOUND_ROWS a.id, a.advert_category_id, c.name AS category, a.advert_type, a.advert_picture, a.advert_header , a.advert_text , a.postalcode FROM advert AS a INNER JOIN category AS c ON a.advert_category_id = c.id WHERE advert_magazin_id = '".$magazin->id."' AND a.advert_start_date <='".$DatumHeute."' AND a.advert_end_date >='".$DatumHeute."' AND a.aktiv='1' ".$SEARCH_SQL." ORDER BY c.name ASC LIMIT ".(($CURRENT_PAGE-1)*$MAX_DATA_PER_PAGE).",".$MAX_DATA_PER_PAGE; */ $SQL = "select SQL_CALC_FOUND_ROWS a.id, a.advert_category_id, c.name AS category, a.advert_type, a.advert_picture, a.advert_header , a.advert_text , a.postalcode FROM advert AS a INNER JOIN category AS c ON a.advert_category_id = c.id WHERE advert_magazin_id = '".$magazin->id."' AND a.aktiv='1' AND a.id IN (SELECT advert_id FROM advert_magazin_release WHERE advert_start_date <='".$DatumHeute."' AND advert_end_date >='".$DatumHeute."') ".$SEARCH_SQL." ORDER BY c.name ASC LIMIT ".(($CURRENT_PAGE-1)*$MAX_DATA_PER_PAGE).",".$MAX_DATA_PER_PAGE; $rsLoadAdverts = dbq($SQL); $SUM_DATA = dbfo(dbq("SELECT FOUND_ROWS() as c")); $SUM_DATA = $SUM_DATA->c; $SUM_PAGES = max(ceil($SUM_DATA / $MAX_DATA_PER_PAGE),1); ?>
Suchbegriff: Ort: Rubrik:  
Bitte benutzen Sie die Suche, um die passenden Anzeigen auszuwählen.

()
advert_type==2){?>bgcolor="#F0FFF0"> advert_picture==1){?>

Es wurden keine Kleinanzeigen gefunden.

= 1) { ?>< vorherige Seite Seite von nächste Seite >