I need to run an UPDATE query and find out the number of rows affected, but the query doesn't return a result identifier. Instead it returns 1 (I guess this means success, but I need the result identifier). My code is:
//
$query = "UPDATE searchlog SET count=count+1 where text='$s1';";
$result = mysql_db_query($db, $query);
$nrows = mysql_affected_rows($result);
//
Mysql returns Invalid Result Identifier on th last line where it does mysql_affected_rows($result)
Any help?
//
$query = "UPDATE searchlog SET count=count+1 where text='$s1';";
$result = mysql_db_query($db, $query);
$nrows = mysql_affected_rows($result);
//
Mysql returns Invalid Result Identifier on th last line where it does mysql_affected_rows($result)
Any help?