count

[JamesGMills]

Hi everyone,

I have a table full of blog posts. I dont want to create a table just to log hits so i thought i would add a column to that table called 'views'.

I want to create a SQL UPDATE to count++ this, can it be done just int eh sql?

James

------------------------

http://www.jamesmills.co.uk

 

[feherke]

Hi

Like this ?

[b]update[/b] [green][i]thetable[/i][/green] [b]set[/b] view=view+1 [b]where[/b] [green][i]theid[/i][/green]=whatever;

Feherke.

http://rootshell.be/~feherke/

 

[JamesGMills]

Thats the one... as if it was that easy... should have had a shat at that one myself really...

Cheers!

------------------------

http://www.jamesmills.co.uk