From: matt at 1lsn dot com
Operating system: Slackware 8.1
PHP version: 4.3.4
PHP Bug Type: MySQL related
Bug description: mysql_num_rows returns error when empty instead of 0
Description:
------------
when doing a mysql_num_rows, if there are no matching rows it gives an
error instead of returning 0.
Reproduce code:
---------------
$Query = "SELECT * FROM MyTable WHERE Field1 = '1' and Field2 = '2' ";
$Result = mysql_query($Query) or die("Error101: ".
mysql_error()."<BR>".$Query);
$CNT = mysql_num_rows($Result) OR DIE("Error 102:
"."<BR>".mysql_error()."<BR>".$Query."<BR>");
echo "There are ".$CNT." matching results. ";
Expected result:
----------------
$CNT should be set to '0' and page should display
"There are 0 matching results."
Actual result:
--------------
Error 102:
SELECT * FROM MyTable WHERE Field1 = '1' and Field2 = '2'
--
Edit bug report at http://bugs.php.net/?id=26187&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=26187&r=trysnapshot4
Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=26187&r=trysnapshot5
Fixed in CVS: http://bugs.php.net/fix.php?id=26187&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=26187&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=26187&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=26187&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=26187&r=support
Expected behavior: http://bugs.php.net/fix.php?id=26187&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=26187&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=26187&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=26187&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=26187&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=26187&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=26187&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=26187&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=26187&r=float
