Hits this week counter

Posted on 16th Feb 2014 07:03 pm by admin

I have a counter on my site that tracks hits, IP's, etc. into a mySQL database. It also includes the date in the entry. The code I'm using, that's not working, to try and retrieve the amount of hits in the last 7 days is:
$hitsWeek = mysql_result(mysql_query("SELECT SUM(`hits`) FROM `stats` WHERE `date` > '$time-604800' GROUP BY `date`"),0);
However, I'm getting this error: Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 10 in /var/www/main.php on line 50

Can anybody help me out with this?

Your Answer:

Login to answer

Other forums

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

Email logic not working
I would like to send an email using the php email() function then if it does execute i.e sends i wou

how can i display php source code snippets ?
I am outputting some pho code .. and I want to display the source code so people can copy and paste

Spaghetti Code
So.

I've pretty much reached the point where I have so many isset s on one page that I can't

Error in query: Resource id #4??
hey guys, having a minor (i think) problem here that i havent been able to figure out. long story sh

Array help
Hello i got this code to fetch data from database but it is not working it displays
7
Array

Comparing Values
Hi
I'm reading data from a database and this seems to work OK.

Each system has an associat

using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the butto

Image DPI
Hi.

I allow users to upload images, the user then is able to adjust several settings for the

Extra fields in main body and php required.
I'm new to PHP so please be gentle. I have a little php script below that works well.
The &quo