if(isset($_REQUEST["searching"]))
{
$sqlProduct="select * from products order by ProductName asc ";
}
else if ($_REQUEST["CategoryID"])
{
$sqlProduct="select * from products,categories where products.CategoryID=categories.CategoryID and products.CategoryID=".$_REQUEST['CategoryID'];
}
else
{
$sqlProduct="select * from products order by CategoryID asc ";
}
$resultSellingLeads=mysqli_query($link, $sqlProduct);
if(@mysqli_num_rows($resultSellingLeads)!=0)
{
while($product_row=@mysqli_fetch_array($resultSellingLeads))
{
$ProductNameLower = $product_row['ProductName'];
$ProductNameLower = strtolower($ProductNameLower);
?>