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

Search function
I am looking for some guidance from the experts.

I am trying to create a search function. It

function not returning the correct value
I have a program that needs to return a value from a function. I have an output statement inside the

Query output more than expected
$query=mysql_query("SELECT * FROM players, communities, divisions WHERE dob BETWEEN '{$start_da

Require select-option functionality in Module Pool Programming
Hi Gurus,

I am doing a development by Module Pool on Warehouse Management. For that devel

Extending Exception to contain method name
I was wondering, if there's a way to extend Exception in such a way, that it would contain name of a

mr8m - reverse document
Friends,

I'm trying to reverse a document held by MIRO, but it reports the message balan

Problem with variable declaration in switch statement
Hello, I am having some trouble assigning a value to a variable inside a switch statement. What I a

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

Thanks

* Gridview and Detailsview in UpdatePanel, insert mode problem
I have a GridView and DetailsView working together. When a record from Gridview is selected, Detail

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built