[RESOLVED] Increments in database when posts made

[jme]

I have a users table and I would like to create a 'posts made' column so that everytime a user makes a post to the site it incremented its value by 1.

How would I go about this? What sort of SQL statement would I use and what attributes would the database field have to have (if any)?

Many thanks.

Jamie 🙂

[toplay]

Just make the column an integer depending on how large a number you want it to hold. The UPDATE SQL would simply be something like this:

UPDATE table_name SET posts_made = posts_made + 1

Numeric data types:
http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html

Update syntax page:
http://dev.mysql.com/doc/mysql/en/update.html

hth.

[jme]

thanks for the help and the links! 🙂

Jamie