echo $search ?> Information Page and Inventory Listing |
You may do much more sophisticated searches on our inventory page. Simply Click Here, or use the or select Inventory->Inventory Search from the menu above for search instructions. You may also search again from the search bar above. Note to search for a specific model enter the model number complete with no spaces or slashes (i.e. HX300 rather than HX 300 or HX-300). $query = "SELECT ID, Model, Serial, BOM, Pump, Condenser, Controller, Electrical, Manufacturer_Text, Thumb_1 FROM Inventory_Item WHERE MATCH (Text_Desc, Model, BOM, Pump, Electrical, Manufacturer_Text, Condenser,Controller, ID) AGAINST ('".$_GET['search']."' IN BOOLEAN MODE)"; $result = mysqli_query($con, $query); $row_count = mysqli_num_rows($result); if (strcmp($rowbgcolor, "#DDDDFF")) {$rowbgcolor ="CCCCFF";} else {$rowbgcolor ="#DDDDFF";} $doc_query = "SELECT * FROM Chiller_Docs WHERE MATCH (Keywords) AGAINST ('".$_GET['search']."' IN BOOLEAN MODE)"; // echo $doc_query; $doc_result = mysqli_query($con, $doc_query); $doc_row_count = mysqli_num_rows($doc_result); ?>We found echo $doc_row_count ?> Documents for Model echo $search ?> That we think may be useful to you. (Click Description to view PDF documents) |
echo "We found ".$row_count." Items in our stock that we think might interest you\n" ?>. Click on ![]() |
|||||
![]() |
Photo |
Manufacturer |
Model |
Condenser |
Serial |
No Image Available | ";
} else {
?>
echo "Model: ".$row['Model'] ?>" class="MagicZoom" rel="show-title: top; title-source: #zoom-header- echo $row['ID'] ?>; initialize-on: mouseover; entire-image: true; zoom-position: right; zoom-align: center;"> |
}
?>
echo $row['Manufacturer_Text'] ?> |
echo $row['Model'] ?> |
echo $row['Condenser'] ?> |
echo $row['Serial'] ?> |
BOM |
Pump |
Controller |
Electrical |
||
echo $row['BOM'] ?> |
echo $row['Pump'] ?> |
echo $row['Controller'] ?> |
echo $row['Electrical'] ?> |
||
require 'creditcontact.html';
require 'W3footer.html';
?>
|