if(empty($Search)) { // For each of the five priority levels. for($z=1; $z<6; $z++) { if(is_numeric($CategoryPassedBack)) { // Firstly check if there are is machinery within the table with the priority level $z. $query = sprintf("SELECT * FROM Machinery WHERE Priority=$z AND Category=%s", quote_smart($CategoryPassedBack)); // Count the number of machines within the table with a priority level $z. $num = mysql_num_rows(mysql_query($query)); // If there are no machines with priority level $z, do not attempt to display them. // $query1 is set to blank. // Errors are displayed when attempting to display machines with a priority level $z when there isn't a machine with priority level $z in the table. if($num == 0) { $query1=""; } else { // Select all itesm from the Machinery-Category which was passed from the previous page. $query1 = sprintf("SELECT * FROM Machinery WHERE Category = $CategoryPassedBack AND Priority=$z ORDER BY Make ASC LIMIT %s, %s", quote_smart($from), quote_smart($max_results)); $x = mysql_num_rows(mysql_query($query)); echo "Priority " . $z . ". Rows: " . $x . "
"; // $z = $z - $x; display_machinery($query1); } } // A Machinery-Category was not passed from the previous page. else { $query = "SELECT * FROM Machinery WHERE Priority=$z"; $num = mysql_num_rows(mysql_query($query)); if($num == 0) { $query1=""; } else { // Select all items in the database. $query1 = sprintf("SELECT * FROM Machinery WHERE Priority=$z ORDER BY Make ASC LIMIT %s, %s", quote_smart($from), quote_smart($max_results)); $x = mysql_num_rows(mysql_query($query)); echo "Priority " . $z . ": Rows: " . $x . "
"; // $z = $z - $x; display_machinery($query1); } } } } else { // Select all rows where Make, Model and Specifics are like the string that the user searched for. $query = sprintf("SELECT * FROM Machinery WHERE (Make LIKE %s) OR (Model LIKE %s) OR (Specifics LIKE %s)", quote_smart("%" . $Search . "%"), quote_smart("%" . $Search . "%"), quote_smart("%" . $Search . "%")); $result = mysql_query($query); $num = mysql_num_rows($result); if($num == 0) { echo "Search Returned No Results.
Click Here To Return Home."; $query1=""; } else { // Select all items in the database. $query1 = sprintf("SELECT * FROM Machinery WHERE (Make LIKE %s) OR (Model LIKE %s) OR (Specifics LIKE %s) ORDER BY Make ASC", quote_smart("%" . $Search . "%"), quote_smart("%" . $Search . "%"), quote_smart("%" . $Search . "%")); display_machinery($query1); } }