|\(|\)|\/|\%/"," ",trim($auto)); $mnr = preg_replace("/=|\^|!\"|\[|\]|\?|\´|\`|\#|\*|\'|\<|\>|\(|\)|\/|\%/"," ",trim($mnr)); $rb2 = preg_replace("/=|\^|!\"|\[|\]|\?|\´|\`|\#|\*|\'|\<|\>|\(|\)|\/|\%/"," ",trim($rb2)); $rb = preg_replace("/=|\^|!\"|\[|\]|\?|\´|\`|\#|\*|\'|\<|\>|\(|\)|\/|\%/"," ",trim($rb)); mysql_connect($hostname, $dbusername, $dbpassword) ; mysql_select_db($dbname) or die("Could not select database !"); ##################### Prufen Daten ######################## $mnr = trim($_GET[mnr]); $auto = trim($_GET[auto]); $rb2 = trim($_GET[rb2]); $rb3 = trim($_GET[rb3]); $page = trim($_GET[page]); #################### if Modelnummer ########################### $ling_mnr = "&mnr=$mnr"; if($mnr){ $select_mnr = "and aat_ct2_id = '$mnr'"; } #################### Wenn Rubrik 2 ############################## if($rb3){ $join_art_rub = "JOIN artikel_rubrik on arb_rb3_id = '$rb3' and aat_ard_id = arb_ard_id";} elseif($rb2){ $join_art_rub = "JOIN artikel_rubrik on arb_rb2_id = '$rb2' and aat_ard_id = arb_ard_id";} else { $join_art_rub = "JOIN artikel_rubrik on arb_rb2_id is not null and aat_ard_id = arb_ard_id";} $r = "SELECT * From artikel_auto LEFT JOIN categories on cat_id = aat_cat_id LEFT JOIN categories_2 on ct2_id = aat_ct2_id LEFT JOIN categories_3 on ct3_id = aat_ct3_id $join_art_rub JOIN artikel_daten on ard_id = arb_ard_id and ard_zeigen != '2' LEFT JOIN artikel_preise on apr_ard_id = arb_ard_id LEFT JOIN artikel_versandkosten on avk_ard_id = arb_ard_id LEFT JOIN artikel_statistik on ast_ard_id = arb_ard_id LEFT JOIN artikel_laufzeit on alz_ard_id = arb_ard_id WHERE aat_cat_name = '$auto' $select_mnr "; # print " $r "; $pk = mysql_fetch_array( mysql_query( "$r")); $print_rb2 = ""; $print_rb3 = ""; $print_auto = ""; $print_cat_name = ''; $print_ct2_name = ''; $print_rb2_name = ''; $print_rb3_name = ''; if($auto) { $print_cat_name="$auto "; } if( $mnr ) { $print_ct2_name=" / $pk[ct2_name]"; $print_rb2 = $pk[ct2_name]; } if( $rb2 ) { $print_rb2_name=" / $pk[arb_rb2_name]"; $print_rb3 = $pk[arb_rb2_name];} if( $rb3 ) { $print_rb3_name=" / $pk[arb_rb3_name]"; $print_auto = $pk[arb_rb3_name]; } ####################### Rubrik für Passende Auto ############################# $pr[aat_ct2_name] if( $mnr ){ $where_mnr = " and aat_ct2_id = '".trim($mnr)."'"; $link_mnr = "&mnr=".trim($mnr);} $qr = mysql_query("SELECT distinct arb_rb2_name,arb_rb2_id FROM artikel_auto Join artikel_rubrik on arb_ard_id = aat_ard_id WHERE aat_cat_name = '$auto' $where_mnr ORDER BY arb_rb2_name ASC "); $key_words = "$auto $print_auto,"; while ( $pr = mysql_fetch_array( $qr ) ) { $pr_rubrik .= "$pr[arb_rb2_name]  "; $key_words .= " $pr[arb_rb2_name],"; } ?> <? print "$auto $print_rb2 $print_rb3 $print_auto"; ?> Kostenlose Autoteile Anzeige
 

Ersatsteile für
 
 $pr_rubrik"; ################## Gorisont Menu #################### $results = mysql_query( "$r"); $quantiti = mysql_num_rows($results); if( !$page ){ $page = '0'; } print MenuLinks($quantiti,$page,"?auto=$auto&rubrik=$rubrik2&mnr=$mnr&rb2=$rb2&rb3=$rb3&page=",$rows_in_page)."
"; $request .= " LIMIT ". (($page -1) * $rows_in_page + $rows_in_page ) .", ". $rows_in_page ; ########### Quere NEU ################# $neu_art = $r ." ORDER BY aat_insertzeit DESC $request "; #################################### $neu_res = mysql_query($neu_art) or die("Invalid query Neu Artikel : " . mysql_error()); # print "
"; while ( $p = mysql_fetch_array($neu_res) ) { print ""; } # print "
"; if($p[ard_bild1]){ print "
$p[ard_bezeichnung]
";} print"
$p[ard_bezeichnung] $p[aat_ct2_name] $p[aat_ct3_name] ". substr(strip_tags($p[ard_beschreibung]),0,100)."... $p[apr_vkpreis] $txt[euro]
$txt[lieferkosten]
+ $p[avk_preis] $txt[euro]
$p[arb_rb2_name] $p[arb_rb3_name]
".MenuLinks($quantiti,$page,"?auto=$auto&rubrik=$rubrik2&mnr=$mnr&rb2=$rb2&rb3=$rb3&page=",$rows_in_page); print "
"; ?>