"; $prod_name = tep_db_query("select product.name, product.description, supplier.instructions, supplier.dba_name as supplier, supplier.description as supplier_desc, supplier.faqs as supplier_notes from product, supplier where product.id = '".$products_id."' and supplier.id = product.supplier_id"); $prod_name_val = tep_db_fetch_array($prod_name); ?> <?=TITLE;?> - Product Information - <?=$prod_name_val['supplier'];?> - <?=$prod_name_val['name'];?> ", " ", $prod_name_val['description']));?>">
"; $product_info = tep_db_query("select supplier.dba_name as supplier_name, supplier.image as supplier_image, supplier.instructions, supplier.faqs, product.id as product_id, product.name as product_name, product.description as product_description, product_desc.desc as product_desc, product.exception as shipping_info, product.image as product_image, product.lrg_image, product.supplier_part_number as part_number, product.price as product_price, product.retail as product_retail, product.date_added, product.shipping, product.collect, detail_link, product.universal, product.active, product.supplier_id from supplier, product_desc, product where product.id = '" . $products_id . "' and product_desc.id = product.desc2 and product.supplier_id = supplier.id"); if (!tep_db_num_rows($product_info)) { // product not found in database ?> "; //echo "select * from specials2 where MATCH(product_id) AGAINST(\"" . $listing_values['product_id'] . "\" IN BOOLEAN MODE) and active=1 and (CURDATE() BETWEEN start AND end) AND ((site_id = 1)OR(site_id = '".WEBSITE_ID."'))"; if (tep_db_num_rows($check_special)) { //echo"FOUND IT
"; while($special_values = tep_db_fetch_array($check_special)){ if(!$new_price){ switch($special_values['type']){ case "0": unset($new_price); break; case "1": $disc_val = (100 - $special_values['rate']); $new_price = number_format(($product_info_values['product_price'] * ($disc_val/100)),2); break; case "2": $new_price = number_format(($product_info_values['product_price'] - $special_values['rate']),2); break; case "3": $new_price = number_format(($special_values['rate']),2); break; default: } } $show_price = $special_values['show_price']; if($shipping > 0){ if(($special_values['fship']==='1')&&(($special_values['exft']==='0')||(($special_values['exft']==='1')&&($product_info_values['collect']==='0')))){ if((($special_values['ltype'] === '1')&&($product_info_values['product_price'] > $special_values['lrate']))||($special_values['ltype'] != '1')){ $shipping = 0; } } } } } if ($new_price) { if ($show_price == '1'){ $special_price = '$' . $new_price . ''; }else{ $special_price = 'See In Cart'; } } $products_price = ' $' . $product_info_values['product_price']; if (file_exists(DIR_SERVER_ROOT.DIR_CATALOG.'shared/'.$product_info_values['supplier_id'].'/'.$product_info_values['product_image'])){ if ((is_file(DIR_SERVER_ROOT.DIR_CATALOG.'shared/'.$product_info_values['supplier_id'].'/'.$product_info_values['product_image']))&& (strlen($product_info_values['product_image']) > 2)&& ((stristr($product_info_values['product_image'],'.gif'))|| (stristr($product_info_values['product_image'],'.jpg'))|| (stristr($product_info_values['product_image'],'.jpeg')))){ $p_image = HTTP_SERVER.DIR_CATALOG.'shared/'.$product_info_values['supplier_id'].'/'.$product_info_values['product_image']; }else{ $p_image = HTTP_SERVER.DIR_CATALOG.'images/default_product_image.gif'; } }else{ $p_image = HTTP_SERVER.DIR_CATALOG.'images/default_product_image.gif'; } if (stristr($p_image,'default_product_image.gif')){ $p_image = HTTP_SERVER.DIR_CATALOG.'images/default_product_image.gif'; } //echo ""; $part_number = $product_info_values['part_number']; if (($product_info_values['active'] == 1)&&($product_info_values['product_price'] > 0)){ $cart_link = 'Add to wishlist        Add to Cart'; }else{ $cart_link = '     '; } if (strlen($product_info_values['lrg_image'])){ $large_image = true; }else{ $large_image = false; } $image_thumb = ''.$product_name.''; $vehicles = tep_db_query("select product_to_vehicle.yearstart, product_to_vehicle.yearend, product_to_vehicle.note, vehicle_model.Model, vehicle_make.Make from product_to_vehicle, vehicle_model, vehicle_make where product_to_vehicle.product_id = '" . $product_info_values['product_id'] . "' and vehicle_model.ID = product_to_vehicle.vehicle_model_id and vehicle_make.MakeID = vehicle_model.Make_ID order by vehicle_make.Make, vehicle_model.Model"); if (tep_db_num_rows($vehicles)){ while ($vehicles_val = tep_db_fetch_array($vehicles)){ $vehicle_applications .= $vehicles_val['yearstart'] . ' - ' . $vehicles_val['yearend'] . ' ' . $vehicles_val['Make'] . ' ' . $vehicles_val['Model'] . ' ' . $vehicles_val['note'] . '
'."\n"; } }elseif($product_info_values['universal'] == '1'){ $vehicle_applications = 'Universal Product'; } $shipping_text = "Shipping:"; ?>



Got a question?
Call us now at 877-667-7407.
    '.$product_name.''; $pi_entry .= ''; echo $pi_entry; $pi_counter++; while ($pi = tep_db_fetch_array($moreimgs)) { $pi_counter++; $pi_entry = '
  • '.$pi['label'].''; if (strlen($pi['htmlcontent']) > 5) { $pi_entry .= '
    ' . $pi['htmlcontent'] . '
    '; } $pi_entry .= '
  • '; echo $pi_entry; } ?>
'.$product_name.''; ?>
'.$product_name.''; ?>
-->"; ?>
Retail Price:
$
Our Low Price:
Sale Price:
 
 
Free Shipping
$
Truck Freight Shipping Information
 
 
 
Part Number:

Vehicle Applications: