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

Download Image from URL and Upload it
Ok, I have been googling for the last 1/2 hour trying to figure this out, Most likely I'm just not s

How to change Time Zone
HI
I want to change the time zone of the server to another country.How can do that?

Thanks

fopen() security
As i understood the usage of fopen() for it to function correctly the Dir you write to has to be rw

Local file browser with php
Halo..

So this is what i want to create. I have a folder that i share and it has many movies.

Needing Youtube thumb nail fix.
I have a script on a site that pulls in you-tube videos,
The problem is, that the thumb nails for

mysql_affected_rows() usage
Possibly a MySQL issue, but the function that is not behaving in the anticipated way is a PHP functi

Update data to upper case in parent/child tables
Hi Gurus!

In production we have a product table and which is being reference by many tabl

email form (cannot find the problem)
Hello there. I've been having trouble with an email form. Can't find the problem really. I've tested

php call servlet
I have done a php backup application .
So there is a form that user pick some files to zip and d

Problem executing bash script using shell_exec
Hi there,
I created a bash script file using following code to convert doc documents to pdf using