Bearing Search


Advanced Housing Search v 1.3

Enter your search criteria in the fields below. You can use as many or as few search criteria as you want.
Hover your mouse over any of the More Info to find out more about it.
Where available click on the More Info to visit the manufacturers site for more details.
You can also click on the icon to enquire about price and availability from E. Fox Engineers.

* Unfortunately your subscription to use this service expired on *
Please click here to update your account.



= 0 && $num_results != "") { ?> Rolling Element -
"; $threshold_metric = 2; if($measure=="Imperial") { // echo "Imperial "; if ($search_id_imp1 != 0 || $search_id_imp2 != 0) { // echo "$search_id_imp2" ; $search_id = (($search_id_imp1 * 25.4) + ($search_id_imp2 * 25.4)); $search_id = $search_id - $tolerence_id; $search_id2 = $search_id + ($tolerence_id * 2); } if ($search_od_imp1 != 0 || $search_od_imp2 != 0) { $search_od = (($search_od_imp1 * 25.4) + ($search_od_imp2 * 25.4)); $search_od = $search_od - $tolerence_od; $search_od2 = $search_od + ($tolerence_od * 2); } if ($search_w_imp1 != 0 || $search_w_imp2 != 0) { $search_width = (($search_w_imp1 * 25.4) + ($search_w_imp2 * 25.4)); $search_width = $search_width - $tolerence_w; $search_width2 = $search_width + ($tolerence_w * 2); } } $query = "SELECT * FROM housing_data WHERE "; if($search_element) { $xquery .= " sub_element='".$search_element."' AND "; } if($search_brand) { $xquery .= " brand='".$search_brand."' AND "; } // BORE if($search_id != '' & $search_id2 == '' ) { $xquery .= " id LIKE ".$search_id." AND "; } else if($search_id != '' & $search_id2 != '' ) { $xquery .= " ( id>=".$search_id." AND id<=".$search_id2." ) AND "; } // BHC $search_od_sml = $search_od - $threshold_metric; $search_od_big = $search_od + $threshold_metric; if($search_od != '' & $search_od2 == '' ) { $xquery .= " (( bhc >=".$search_od_sml." AND bhc <= ".$search_od_big." ) OR bhc = 0 ) AND ";} else if($search_od != '' & $search_od2 != '' ) { $xquery .= " (( bhc >=".$search_od_sml." AND bhc <=".$search_od_big." ) OR bhc = 0 ) AND "; } // HTC $search_htc_sml = $search_width - $threshold_metric; $search_htc_big = $search_width + $threshold_metric; if($search_width != '' & $search_width2 == '' ) { $xquery .= " (( htc >=".$search_htc_sml." AND htc<=".$search_htc_big.") OR htc = 0 ) AND "; } else if($search_width != '' & $search_width2 != '' ) { $xquery .= " (( htc >=".$search_htc_sml." AND htc<=".$search_htc_big." ) OR htc = 0 ) AND "; } if($search_name) { $search_name_strip = $search_name; $search_name_strip = str_replace(" ", "", $search_name_strip); $search_name_strip = str_replace("*", "", $search_name_strip); $search_name_strip = str_replace("/", "", $search_name_strip); $search_name_strip = str_replace("-", "", $search_name_strip); $xquery .= " ( designation LIKE '%".$search_name."%' OR designation2 LIKE '%".$search_name_strip."%' OR `insert` LIKE '%".$search_name."%' OR housing_code LIKE '%".$search_name."%' ) AND "; } $query .= " ".$xquery." 1=1 ORDER BY sub_element,type,id, designation ASC"; // echo $query; if($_SESSION['company'] != "E. Fox Engineers Ltd") { mail("alan.fox@efox.ie", "Brg Search - ".$_SESSION['company']." ".$_SESSION['email']."", $query); } if($xquery != "") { $count = 0; $current_element = "zzz"; $current_type = "zzz"; $num_results = 0; $result = mysql_query($query); while($row = mysql_fetch_array($result)) { // $id = $row["id"]; //$od = $row["od"]; //$width = $row["w"]; $type = $row["type"]; $designation = $row["designation"]; //$element = $row["element"]; $sub_element = $row["sub_element"]; if($current_element != $sub_element) { // echo " :".$current_element.": != :".$sub_element.":
"; $current_element = $sub_element; ?>
/", "-", $sub_element); //$image = preg_replace("/ /", "_", $image); $image = "bearing_search/images/".$image.".gif"; //echo "$image"; if(file_exists($image)) { echo ""; } //else //{ echo ""; } ?> - Click to expand
"; // echo "Current Type: $current_type
"; if($current_type != $type) { $current_type = $type; ?>
/", "-", $type); //$image = preg_replace("/ /", "_", $image); $image = "bearing_search/images/".$image.".gif"; //echo "$image"; /* if(file_exists($image)) { echo ""; } else { echo ""; } */ ?>
bgcolor="#CCCCFF" >
Bore Bolt Hole Centre Height to Centre Overall Width Overall Height Weight Designation Brand Insert Options
"; $link = "http://www.koyousa.com/KoyoCatalog/SearchBearingResults.aspx?tp=2&txt=".$designation3ulr.""; } else if($brand3 == "SKF") { echo ""; $link = "http://www.skf.com/skf/productcatalogue/jsp/search/searchDesignation.jsp?action=search&searchway=1&lang=en&maincatalogue=1&designationField=".$designation3ulr.""; } else if($brand3 == "FAG" || $brand3 == "INA") { echo ""; $link = "http://medias.ina.de/medias/en!hp.ds/;ab54Yh_iW56d?pattern=".$designation3ulr.""; } else if($brand3 == "KML") { echo ""; $link = "http://www.kml-bearing.com/products/bearings/mounted_bearing_units_and_inserts_show.jsp?bearing_no=".$designation3ulr.""; } else if($brand3 == "CX") { echo ""; $link = "http://e-katalog.home.pl/CX_BEARINGS/fullscreen2.php?index=".$designation3ulr."&grupa=0&norma=0&rodzaj_wymiar1=R&wymiar1=&rodzaj_wymiar2=R&wymiar2=&rodzaj_wymiar3=R&wymiar3=&w=1"; } ?> ";} ?>
More Info More Info More Info


  You must be logged in to see these results. $login_error "; } ?>
Email :
Password :
 
  Click here to register

     Housing Search
For sales enquiries please contact the sales team on 01 4693500 or sales@efox.ie
For technical assistance please contact Alan - alan.fox@efox.ie - 01 4693500
E. Fox Engineers accepts no responsibility for the accuracy of the data provided.
All data & images displayed on this website are the property of E. Fox Engineers Ltd and may not be copied or reproduced in any form.