This question already has an answer here:
Hi i have done research on this topic i did come across a few solutions, although i wasn't able to implement them to my code because i am a beginner to this. My question is basically how can i display a message if value is not found in the MySQL database?
previously searched: Displaying message when no results found in PHP MySQL search and mysql fetch array if no results display message
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
</head>
<body>
<?php
$customer = $_GET["custID"];
$conn = mysql_connect("localhost", "localuser", "pass");
mysql_select_db("testdb", $conn)
or die ('Database not found ' . mysql_error() );
$sql = "SELECT orderNumber, customerID, orderDate, shippingDate, shipped FROM orders where customerID = $customer ORDER by orderDate";
$rs = mysql_query($sql, $conn)
or die ('Problem with query' . mysql_error());
?>
<table border="1" summary="Customer Details">
<tr>
<th>Order Number</th>
<th>Customer ID</th>
<th>Order Date</th>
<th>Shipping Date</th>
<th>Shipped</th>
</tr>
<?php
$results = mysql_fetch_array($rs);
if ( $results === FALSE )
{
echo "No result";
}
else
{
foreach($results as $item)
{?>
<tr>
<td><?php echo $result["orderNumber"]?></td>
<td><?php echo $result["customerID"]?></td>
<td><?php echo $result["orderDate"]?></td>
<td><?php echo $result["shippingDate"]?></td>
<td><?php echo $result["shipped"]?></td>
</tr>
<?php }
}
mysql_close($conn); ?>
</table>
</body>
</html>
</div>
Use mysql_num_rows()
if(mysql_num_rows($rs) > 0) {
// got records
}
else {
// no records found
}
Note:
Don't use mysql_* family functions because they are going to deprecated. Start to look into mysqli or pdo
This usage if(count($result > 0)) is wrong. mysql_fetch_row always returns FALSE when there is no result. Please see: http://php.net/manual/en/function.mysql-fetch-array.php
You should use sometime like that
<?php
$results = mysql_fetch_array($rs);
if ( $results === FALSE )
{
echo "No result";
}
else
{
foreach($results as $item)
{
...
}
}
?>
$result = mysql_fetch_array($rs)
if($result)
...