Auto Incrementing

[admin]

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