I have these two queries:
$dbh
->prepare("UPDATE user
SET reputation = reputation - 15
WHERE id = ?")
->execute(array($old_author));
$dbh
->prepare("UPDATE user
SET reputation = reputation + 15
WHERE id = ?")
->execute(array($new_author));
I want to know can I do that by one single query? I mean can I both - 15 and + 15 in reputation column for two users in the same query?
Aucun commentaire:
Enregistrer un commentaire