Help anyone?

I have a field in my database called views and i'd like to output the total number of views that have been generated by calculating all of the views in the table together... Can anybody help me with a quick code to output this?

Thanks in advance =].

 

select the field in the db, and using "while.." statement add the values then return the total.

 

No while() loop needed.

SELECT SUM(views) AS total FROM table_name

Code (sql):

 

Thanks alot mate.

One more thing, i want to include a file in my site which resets my viewtoday field to 0, but only once after 12:01 of a new day.

$query = "UPDATE table SET viewtoday=0 where active = 'yes'";

Anybody know how i would do this? I've had the code before from somebody but i lost it.

Thank you

 

Okay nevermind, sorted it now - thanks again!

 

Best way to do this is not a query in a web page - use cron jobs to run the query at whatever time you choose.

D