mysql_db_query result if no records

[Anon]

What is the most reliable way to make sure
that query returns no records ?

It seems like in this case mysql_db_query
returns empty string but there is nothing about it in docs. Is empty string what I should check for ?

Thanks

[Anon]

You could just set a variable equal to mysql_nunm_rows. If the number of rows returned is less than 1, you know there are no records...

Example:

$sql = "your statement";

$result = mysql_query($sql);

if ($result) {
$count = mysql_num_rows($result);
if ($count < 1) {
do something here;
}
}

[Anon]

James T wrote:

It seems like in this case mysql_db_query

returns empty string but there is nothing about it in docs.

from the docs:

"mysql_query() returns TRUE (non-zero) or FALSE to indicate whether or not the query succeeded. A return value of TRUE means that the query was legal and could be executed by the server. It does not indicate anything about the number of rows affected or returned. It is perfectly possible for a query to succeed but affect no rows or return no rows. "

so, mysql_query returns a boolean value, true or false. Hence you can test it as the previous reply stated.