PHP mysql_affected_rows() Function
 Complete PHP MySQL Reference
Definition and Usage
The mysql_affected_rows() function returns the number of affected rows in the previous MySQL operation.
This function returns the number of affected rows on success, or -1 if the last operation failed.
Syntax
mysql_affected_rows(connection)
|
| Parameter |
Description |
| connection |
Optional. Specifies the MySQL connection. If not specified,
the last connection opened by mysql_connect() or mysql_pconnect() is used. |
Example
<?php
$con = mysql_connect("localhost","mysql_user","mysql_pwd");
if (!$con)
{
die("Could not connect: " . mysql_error());
}
mysql_select_db("mydb");
mysql_query("DELETE FROM mytable WHERE id < 5");
$rc = mysql_affected_rows();
echo "Records deleted: " . $rc;
mysql_close($con);
?>
|
The output of the code above could be:
Complete PHP MySQL Reference
 |
|
|
See why there are 20,000+ Ektron integrations worldwide.
Request an INSTANT DEMO or download a FREE TRIAL today. |
|
|
|
