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

Loop Through Date Range
Hi guys,
I have date range as parameter like 01/JAN/2009 TO 16/JAN/2009 now i want to loop thro

Quick variable question
hey guys/gals,
im trying to write a php script and it works fine as i have it, but i need to set

Getting PHP to ammended the selected in option field
Hey Guys

thanks for everyones help so far. This site and its users are oozing awesomness.

PHP friend keyword equivalent
is there a PHP equivalent for the C++ friend keyword?

Extract specific information from a PHP Multidimensional Array
Howdy! I've racked my brain over this for 24 hours now. I think it's time I asked for help. I'm lear

Timer control causing error
I recently decided to add a timer control to an existing page that uses AJAX on my site. As soon as

private constructor
Hello,

Can we create a constructor as private? If yes, what is the use of it? If no, why can'

Get word number x from string?
How can I use a function to loop through a string, and "have a look at" every word in the

Just wondering what you think about my site
I am new to phpfreaks i just seen this form and thought it would be cool to see what other thought a

Windows Authentication
I have a website which is windows authenticated.
now i want something more on this application.<