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

SAP Treasury - Commodities
We are running SAP ECC 6.0 with Treasury Activated.
EA-FIN is also activated (SFW5).

why does my session end?
my connect.php starts the session just so you know
i can navigate arround my site fine except whe

PHP Upload issue
Hi guys,

I have stumble across an interesting issue with my script and is doing my head in.

PHP, Arrays & A Lot Of Confusion
I've been doing basic PHP work on sites for a few years now, but I've never been tempted to learn ho

Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the

PHP Mysql Staff Induction System
Hi there, I'm pretty new to PHP and Mysql so could really do with being pointed in the right directi

DOMDocument parsing
Hello, I am parsing an xml file from an API which I have converted into a DOMDocument in php. This i

Is there a way to override built in php functions without APD?
I am trying to use the
rename_function()
override_function()
options that are built into

Curl timeout breaks script
So im having difficulties with skipping timeout error in curl
my script calls different functions

Inserting multiple records from single form
I've found a number of threads that deal with this issue, but I'm new to php and coding language so