With php/mysql how can i get the number of rows that a query affected?
what i tried so far:
$result = mysql_query($q);
mysql_num_rows($result);
but it says that Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
-
3php.net/manual/en/function.mysql-affected-rows.phpAllisonC– AllisonC2011-12-02 13:16:02 +00:00Commented Dec 2, 2011 at 13:16
-
@AllisonC you should post that as an answer.. :)SERPRO– SERPRO2011-12-02 13:16:33 +00:00Commented Dec 2, 2011 at 13:16
-
The warning indicates that the query failed rather than that you are using the wrong function. You should implement proper error handling.Till Helge– Till Helge2011-12-02 13:18:28 +00:00Commented Dec 2, 2011 at 13:18
Add a comment
|
5 Answers
if you're using PDO (wich i would recommend), for a direct query exec() returns the number of affected rows. for Prepared Statements theres a method called rowCount().
if you're using the mysql-functions, there's mysql_affected_rows().
EDIT:
seems like you're using the mysql-functions. mysql_num_rows, wich is what you're using, returns the length of your result set (for SELECT-Statements for example). what you need to use is mysql_affected_rows (as already said).
3 Comments
clamp
thanks, but even then i get this error: Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource
Pateman
You need to supply
mysql_affected_rows with the connection identifier, not the result record, as written on php.net/manual/en/function.mysql-affected-rows.phpYou also may want to use a ROW_COUNT() function, e.g. -
UPDATE table1 SET column1 = 100 WHERE column2 = 10;
SELECT ROW_COUNT();
From the reference - ROW_COUNT() returns the number of rows changed, deleted, or inserted by the last statement if it was an UPDATE, DELETE, or INSERT...
Comments
clamp,
you need to supply a resource to mysql_affected_rows, not a result record. See the links that the others have posted for additional information.
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
$result = mysql_query($q);
echo mysql_affected_rows($link);
Comments
Whe can also do it using PDO :
$db = new PDO('', '', '')// your connection
$sql = "UPDATE tb_table SET rowname = value WHERE rowid = 1";
$query = $db->query($sql);
echo $query;
1 Comment
nekiala
$sql must be replaced by your own request