[Solved] SQL, PHP update query

by


Use the mysql_affected_rows function to find the number of records affected. Please see following code.

 $record = mysql_query("update table set a="$b", b='$c' where id = '$id' "); 
 $total_rows = mysql_affected_rows($conn);
 echo $total_rows;

where $conn is the connection object

0

solved SQL, PHP update query