Auto Incrementing

Anon

I am trying to use the update command to increment a field by one. The purpose of this field is to keep track of how many times the user has posted a message on a bulletin board. I want to send a line that will update the field by one. I don't need it to create a new row, just increment this field by one.

$query = "UPDATE tablex SET counter = counter++";

Thanks,
Daniel Ice

Anon

IANAE, but some of the more obvious things I noticed:

[] No WHERE clause.
[*] Not sure if MySQL/whatnot supports "row = row++"

I would probably modify it a bit into something more like: (the following is untested (psuedo-)code, use at your own risk)

// Get current "counter" value
...
// Query String
$query_String = "UPDATE tablex WHERE user = " . $posting_USER . " SET counter = " . $curcounter++;

Hope that helps,
--WorldMaker--

Anon

As WorldMaker notes, you need a WHERE clause.

I don't think that MySQL supports the ++ operator, and SQL92 probably doesn't have it either, so re-write to:

$query = "
UPDATE tablex
SET counter = counter + 1
WHERE userID=$userID
";

(Make sure that you check the $userID value before you introduce it into an SQL expression. If $userID is an integer, then you could start by forcing it to be an integer, using the intval() function.)