PHP 4.0 Bug #6483: mysql_affected_rows not functioning
| From: | tsmith at qsigroup dot com | Date: | Fri, 01 Sep 2000 15:40:15 +0000 |
| Subject: | PHP 4.0 Bug #6483: mysql_affected_rows not functioning | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-31587@lists.php.net to get a copy of this message | ||
From: tsmith@qsigroup.com
Operating system: osx server
PHP version: 4.0.1pl2
PHP Bug Type: MySQL related
Bug description: mysql_affected_rows not functioning
I upgraded to PHP Version 4.0.1pl2 and mysql_affected_rows no longer works. mysql_num_rows works,
but all my pages that query the DB using a DELETE, UPDATE, and INSERT and checking with
mysql_affected_rows returns nothing. It worked when I had PHP3. Did the format change???
$queryB = "INSERT INTO $userstable (l_name, f_name, title, business, address, city, state,
zipcode, bus_tel, bus_fax, email) VALUES
('$l_name','$f_name','$title','$business','$address','$city','$state','$zipcode','$bus_tel','$bus_fax','$email')";
$resultB = MYSQL_QUERY($queryB);
@$numberB = MYSQL_AFFECTED_ROWS($resultB);
PRINT "This is numberB: ".$numberB."<BR>";
if ($numberB != "1")
{
PRINT "<CENTER><H3>Insert into PRSA was
unsuccessful.</CENTER></H3>";
EXIT;
}
}
PRINT "<CENTER><H3>Insert was successful!</CENTER></H3>";