Mega Code Archive

 

Categories / Php / MySQL Database

 

Get affected rows for an update

<?php    mysql_connect("mysql153.secureserver.net","rntsoft","password");    mysql_select_db("rntsoft");    $query = "UPDATE Employee SET salary = '39.99' ";    $result = mysql_query($query);    echo "There were ".mysql_affected_rows()." product(s) affected. "; ?>