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

Need help with cin setw
I made a program here is my code:

#include
#include
#i

PHP search multiple input field box help
I am having a problem with my search script. At current it will simply search by a selected date whi

Time-based image rotation script
I'm trying to write a PHP script that rotates an image based on what time of day it is. I want the

Menu restriction
How can I restrict the individual menu that would appear when a user logs in so that all users are c

Displaying returned XML in another PHP page
I have an online payment form that will return XML given if a payment is successful or declines. I

PEAR Email Attachment w/ $gpg
I have no issues with this code if I take out the attachement section and include the info in the em

MVC - Code review
I'm in the process of trying to wrap my head around MVC, and as part of that, I'm attempting to impl

Sum of Values in an Array
This is probably really simple... but it's been years since I've written anything, so bare with me!<

parameter passing issue on function
Well I thought I had created a pretty slick web page, using ?page and $_GET to load pages which wher

Anti Spam Code
Ok where do i start? Probably by telling you I have very little working knowledge of PHP and that I