PHP 4.0 Bug #7438 Updated: mysql_affected_rows not working

ID: 7438 Updated by: torben Reported By: juancho@metallica.com Status: Closed Bug Type: MySQL related Assigned To: Comments: This is not a bug--mysql_affected_rows() takes as its argument a link identifier (i.e., what you get from mysql_pconnect()), and not a result identifier. Try passing $conn instead of $r and you should get what you want. Hope this helps. Previous Comments: --------------------------------------------------------------------------- [2000-10-24 16:51:38] juancho@metallica.com sorry, the correct query is "update mytable set x='y' where z='p' " --------------------------------------------------------------------------- [2000-10-24 16:46:43] juancho@metallica.com ./configure' '--with-apache=../apache_1.3.14' '--enable-track-vars' '--enable-ftp' '--enable-trans-sid' '--disable-debug' '--enable-magic-quotes' <? $conn=mysql_ponnect("localhost","user","pass"); $r=mysql_db_query("mydb","update x='y' where z='p' ",$conn); $n=mysql_affected_rows($r); echo "n= $n"; ?> It prints "n= " and I get this warning: Warning: Supplied argument is not a valid MySQL-Link resource in /mnt/clientes/sancho/html/classes/manage_users.php on line 143 but the data in the database is beeing modified by the update query. It worked fine with 4.0.1pl2 php.ini: [MySQL] mysql.allow_persistent = On mysql.max_persistent = -1 mysql.max_links = -1 mysql.default_port = mysql.default_host = mysql.default_user = mysql.default_password = --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=7438