Need SQL just to pull total photo views

Swanny · December 12th, 2004, 08:34 PM

Hi, I'm trying to write a single php/sql script that just connects to the db, grabs the total photo views, and outputs that. Help!

Here's what I have so far (it doesn't work):

Code:

Content visible to verified customers only.

b6gm6n · December 13th, 2004, 04:26 AM

here's something which works for me, i echo the amount of comments and total photos...see below

Code:

Content visible to verified customers only.

-T

Chuck S · December 13th, 2004, 11:33 AM

This query would work

$query = "SELECT SUM(views) FROM photos";