"; $k++; $show_image++; } } # ---------- get company details ---------- $sql = "SELECT company_email, fax, phone, address, company_name FROM ".$site."_admin where `username` = '$website_url'"; $result = mysql_query($sql); list ($company_email, $fax, $phone, $address, $company_name) = mysql_fetch_row($result); if ($company_name) { print "

$company_name

"; } if ($address) { print "

$address

"; } if ($phone) { print "

Call $phone

"; } if ($fax) { print "
".$admin_fields["FAX"]." $fax
"; } if ($company_email) { print "
E-mail: $company_email

"; } # ---------- get company details ---------- print "

$row_array[1]

"; # ---------- images ---------- print "
$lightboxlink[0]\"Start
\n"; reset($lightboxlink); print "
\n"; for ($k = 0; $k < sizeof ($show_image1); $k++) { if ($k%3 == 0) { echo "\n\n"; } print "\n"; } if ($k == 2) { print ""; } if ($k == 1) { print ""; } print "
$lightboxlink[$k]\"Start  
\n"; # ---------- images ---------- print "
"; # ---------- description ---------- print "

$frontend_labels[DESCRIPTION]

".nl2br($row_array[2])."
\n"; # ---------- description ---------- # ---------- details ---------- print "

$frontend_labels[SPECS]

\n"; if ( $row_array[20] < 1 ) { $roadtax = ""; } else if ( $row_array[20] > 1 ) { $roadtax = "£ ".$row_array[20]; } $spec_fields = array( "$frontend_labels[MANUFACTURER]" => "$row_array[9]", "$frontend_labels[MODEL]" => "$row_array[12]", "$frontend_labels[FUEL]" => "$row_array[11]", "$frontend_labels[MILES]" => "$row_array[10]", "$frontend_labels[CLASS]" => "$row_array[8]", "$frontend_labels[YEAR]" => "$row_array[13]", "$frontend_labels[PRICE]" => "$default_currency$row_array[14]", "Date First Registered" => "".ymd2dmy ($row_array[22])."", "MOT Expiry Date" => "".ymd2dmy ($row_array[23])."", "$frontend_labels[DOORS]" => "$row_array[3]", "$frontend_labels[COLOUR]" => "$row_array[4]", "$frontend_labels[VIN_NO]" => "$row_array[5]", "$frontend_labels[ENGINE]" => "$row_array[6]", "$frontend_labels[REGISTRATION_PLATE]" => "$row_array[7]", "$frontend_labels[TRANSMISSION]" => "$row_array[16]", "$frontend_labels[OWNERS]" => "$row_array[17]", "Annual Road Tax" => "$roadtax", "Insurance Group" => "$row_array[21]", ); foreach ($spec_fields as $key => $value) { if ($value) { print " \n"; } } print "
$key $value
"; # ---------- details ---------- # ---------- features ---------- $sql1 = "select ".$site."_pars.article_id, ".$site."_car_features.title from ".$site."_pars, ".$site."_car_features where article_id = '$id' and par_id = ".$site."_car_features.id order by ".$site."_car_features.title"; $result1 = mysql_query($sql1); if ( mysql_num_rows ( $result1) > 0) { print "

$frontend_labels[FEATURES]

\n"; while ( $row1 = mysql_fetch_row($result1)) { print "• $row1[1]
\n"; } print "
\n"; } # ---------- features ---------- print "
\n"; include_once "./footer_flyer.php"; ?>