[Resolved] Increment count field by one w/only ONE query?

brockn

The following is psudeo code that allows you to increment a field (say the number of posts a user has) by one. It requires two queries.

$sql = "select post_count from users where username='guy'";
///Blah blah blah
$post_count = $row[0] +1;
$sql = "update users set post_count = '$post_count'";
///Blah blah blah

Is there a way to do this in one query? Basically the following in SQL correct manner.

$sql = "update users set post_count = (post_count + 1)";

Sxooter

$sql = "update users set post_count = post_count+1 where username='guy'";

Drakla

Hi Sxooter.

If he can't use subqueries you can just do the same thing with

update users set post_count = post_count+1 where username='guy';

[EDIT] - Whoah! My mind must be playing tricks, I could have sworn Sxoot's post had a subquery version in it - time for a bath, code-blindness has shadowed reasoning... must... fight it....

brockn

Thank you very much!

Sxooter

Originally posted by Drakla
Hi Sxooter.

If he can't use subqueries you can just do the same thing with

update users set post_count = post_count+1 where username='guy';

[EDIT] - Whoah! My mind must be playing tricks, I could have sworn Sxoot's post had a subquery version in it - time for a bath, code-blindness has shadowed reasoning... must... fight it....

Sorry dude, I realized as soon as I'd written it that it was a super simple query. I was just trying to rewrite it to be the same logic as what he had... then I woke up 🙂

brokn: You're welcome!