From: tpavlakos at yahoo dot gr Operating system: Win2000 SP4 PHP version: 4.3.9 PHP Bug Type: Documentation problem Bug description: mysql_affected_rows: returns correct # of rows when DELETE with no WHERE
Description: ------------ >From the 'mysql_affected_rows' doc page: " If the last query was a DELETE query with no WHERE clause, all of the records will have been deleted from the table but this function will return zero." (At least with MySQL 4.1.10) This doesn't seem to be correct. The correct number of rows deleted is returned. -- Edit bug report at http://bugs.php.net/?id=32251&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=32251&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=32251&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=32251&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=32251&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=32251&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=32251&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=32251&r=needscript Try newer version: http://bugs.php.net/fix.php?id=32251&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=32251&r=support Expected behavior: http://bugs.php.net/fix.php?id=32251&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=32251&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=32251&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=32251&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=32251&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=32251&r=dst IIS Stability: http://bugs.php.net/fix.php?id=32251&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=32251&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=32251&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=32251&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=32251&r=mysqlcfg