How to update a specific row OR RETURN FALSE if it does not exist?

Question

How to do it in one request?

Answer 1

You can do something like:

function updateValue()
{
     mysql_query($sql); // your update goes here
     return mysql_affected_rows() > 0;
}

From the comment of BoltClock:

Keep in mind that mysql_affected_rows () returns 0 if the row exists, but the old and new values ​​are equal (which means no update is required).

Answer 2

You can use the mysql_affected_rows () function to check if any update lines have affected. See http://php.net/manual/en/function.mysql-affected-rows.php for details

Answer 3

.

if(mysql_query('UPDATE table SET key = value WHERE id = 33')){/*....*/}

where , , , , ?