note 11750 added to mysql_affected_rows
| From: | tom at wiredsolutions dot net | Date: | Mon, 05 Mar 2001 22:08:09 +0000 |
| Subject: | note 11750 added to mysql_affected_rows | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-11908@lists.php.net to get a copy of this message | ||
As a reply to andy@occ.nu:
$sqlstat1 = "select * from ".$table." where newsid = ".$newsid." order by
commentid DESC";
$result_handle1 = mysql_db_query($dbase, $sqlstat1);
$a_comments = mysql_affected_rows();
$a_comments does not return the # of affected rows because you must pass it the connection
identifier.
Correct:
$a_comments = mysql_affected_rows($sqlstat1);
http://www.php.net/manual/en/function.mysql-affected-rows.php