echo "
";
//HTML Code
echo "
Equipment Type: | |
Make: | |
Model: | |
";
if ($POST_search_keyword!='')
{
$q1="select compartmentType,lubeQuantity,clsLubeProductName from ".$prefix."_articles where compartmentType like '%$POST_search_keyword%' or lubeQuantity like '%$POST_search_keyword%' or clsLubeProductName like '%$POST_search_keyword%' order by pos asc";
$res1=$db->get_results($q1);
if (count($res1)>0)
{
foreach ($res1 as $row1)
{
$compartmentType=$row1->compartmentType;
$lubeQuantity=$row1->lubeQuantity;
$clsLubeProductName=$row1->clsLubeProductName;
echo " $compartmentType$clsLubeProductName$lubeQuantity "; }; }//End of if (count($res1)>0) else { echo "No results"; };//End of else if (count($res1)>0) };//End of if ($POST_search_keyword!='') echo " |