In article <Pine.OSF.3.91.1010806142332.22209D-100000@leofric>,
 [EMAIL PROTECTED] (Ajdin Brandic) wrote:

> I'm trying to get number of rows from a query. All works fine until 
> the result is 0.  Then query executes fine, returns 0 rows but mysql_numrows 
> failes.
> $query="select * from mytable";
> $result=mysql_query($query) or die("select failed");

mysql_query() returns a result set identifier if the *query was valid* 
(regardless of whether any rows were returned) or else false if the query 
was not valid.  So the line above is "If $query is valid, assign the result 
set identifier to $result; but if $query was not valid, die with this 
message..."  This is different from your next line:

$num_rows=mysql_numrows($result) or die("select count failed");

mysql_num_rows() returns the number of rows in the result set.  So this 
line is "If $query found *one or more* rows, assign the row count to 
$num_rows; but if $query found *zero* rows, die with this message..."

See how they differ?  (Drop the second "or die..." if you want the script 
to continue even where no rows were returned.)


PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to