Check to see if mysql_fetch_array result is empty
| From: | Mike Tuller | Date: | Wed, 12 Mar 2003 19:16:36 +0000 |
| Subject: | Check to see if mysql_fetch_array result is empty | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-139370@lists.php.net to get a copy of this message | ||
How can I check to see if a mysql_fetch_array is empty. I have a search page, and want to have it so that when there are no matches, it returns a message saying that there were no matches, and if there are, then display them. Here is what I have so far to give you an idea as to what I am trying to do.
Thanks
-----------------
$query = "SELECT * FROM software_assets WHERE $searchType LIKE '$search' ";
$db_query = mysql_query($query, $db_connect) or die (mysql_error());
while ($row = mysql_fetch_array( $db_query ))
{
if $row = NULL
{
echo "There were no results that match your query. Please try again";
}
else
{
echo "<tr>
<td align=\"left\"><a href=\"editsoftwareasset.php?id=$row[asset_id]\">$row[asset_id]</a></td>
</td>
<td>$row[developer]
</td>
<td align=\"center\">$row[title]
</td>
<td align=\"center\">$row[version]
</td>
<td align=\"center\">$row[platform]
</td>
</tr>\n";
}
}