How can I make a php statement that will return "sorry, no products found" when mysql query produces no results?
check if mysql_num_rows == 0 on that condition, echo("Sorry ...");
see mysql_num_rows in the www.php.net manual.