I've following sql to update results table:
$mysqli->query("UPDATE results SET result_value = IF('$logo_value' - result_tries < 0 OR '$logo_value' - result_tries = 0, 1, '$logo_value' - result_tries) WHERE logo_id = '$logo_id' AND user_id = '$user_id' AND result_value = 0");
In the same sql command is it possible to update another table based on result_value?
if result_value = 10 Update users SET user_hints = user_hints +1 WHERE user_id = '$user_id'
How would I incorporate this into sql syntax above?