Basic DB question?

[PoLlama]

Just for clarification(this will help me a lot), could someone please give me the code for loading a integer from a database, adding one to it, and saving it back to the database.

Also, for row-types, I notice tinyint4 acts as a boolean, why is that? Shouldn't tinyint2 be a boolean?

[PoLlama]

Come on, there must be a lot of people who know how to do this, its really not a big deal.

I just want...

Get integer from (db)table row
Set integer + 1
Save integer to (db)table row

Whether or not a variable is needed I don't know..

[spottedhog]

Here is an example:

UPDATE (tablename) SET views=views+1;