[PHP-MySql] Can SQL tell me how many row(s) were updated?

Question

I would use only a single query:

$sql = "UPDATE gallery SET order = (order+1) WHERE id_categ = ".$id;
$res = mysql_query($sql);

...

Is it possible?

Answer 1

mysql_affected_rows() should to the job.

Copied from the manual:

<?php
mysql_query("UPDATE mytable SET used=1 WHERE id < 10");
printf ("Updated records: %d\n", mysql_affected_rows());
// Prints: "Updated Records: 10"

Answer 2

You can have a look at something like

• mysql_affected_rows
• PHP mysql_affected_rows() Function

Answer 3

Yes, just use

mysql_affected_rows()

after your query.

$sql = "UPDATE gallery SET order = (order+1) WHERE id_categ = ".$id;
$res = mysql_query($sql);
$rowsAffected = mysql_affected_rows();

Edit: Damn, you guys are fast ;)