Checking if a mysql query was unsuccessful
Posted: Tue Nov 14, 2006 2:07 pm
How would I write a switch statement to check if a mysql returned no results?
At the moment I have
But nothing is ever returned, whether results are returned or not.
At the moment I have
Code: Select all
if ($_GET["page"] == "open") {
$query = mysql_query("SELECT *
FROM customer, jobs
WHERE customer.customerid = jobs.customerid
AND customer.customerid = '$_SESSION[username]'
AND status = 'Not Delivered'");
}
if ($_GET["page"] == "closed") {
$query = mysql_query("SELECT *
FROM customer, jobs
WHERE customer.customerid = jobs.customerid
AND customer.customer = '$_SESSION[username]'
AND status = 'Delivered'");
}
echo "<table border>";
echo "<td bgcolor = 'FFFFCC' valign = 'top'>";
echo "<h2> <b> <u> Delivery Information </u> </b> </h2> <br>";
while ($res4 = mysql_fetch_array($query)) {
switch ($res4) {
case (empty($res4)):
echo "There are no open deliveries";
break;
case (empty($res4)):
echo "There are no closed deliveries";
break;
}