[PHP] Check to see if mysql_fetch_array result is empty

[Mike Tuller]

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";
		}
	}

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php