|
Free shipping on filter orders over $400
(Shipping charges will show at checkout and on invoice but will be removed before billing)
Enter any manufacturers part number in the search box |
| ";
if($mfg_part) {
$conn = pg_Connect("localhost", "5432", "", "", "hydraulicecomm");
if(!$conn) $error = "Database connection was not established ";
if($conn) {
$sql = "select mfg_name,mfg_part,item_code from filters_data
where upper(mfg_part) like upper('%$mfg_part%') ";
$qrr = pg_query($conn,$sql);
$num = pg_num_rows($qrr);
for ($i=0 ; $i < $num ; $i++) {
$mfg_name = trim(pg_Result($qrr,$i,"mfg_name"));
$mfgpart = trim(pg_Result($qrr,$i,"mfg_part"));
$item_code = trim(pg_Result($qrr,$i,"item_code"));
$item_code_c = urlencode($item_code);
$mfgpart = eregi_replace("$mfg_part","$mfg_part",$mfgpart);
$item_link = "$item_code";
$filters_out .= "$mfg_name | $mfgpart | $item_link | ";
}
if($num > 0)
$filters_out_head = "Search Results for : $mfg_part |
MFG Name | MFG Part |
Luber-finers Part | ";
}
}
?>
$filters_out_head $filters_out | ";?>
|
|
|