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

PHP code needed to get/post form fields and request mysql query results.
I'm new to PHP

I've created an html form to allow the user to request a basic telephone dire

Sharing PHP Sessions Across Domains
I am in the process of writing a script to share a php session across various domains I have.
The

To add a field on the screen XK02.
Hi All,

How to add an additional field in the vendor change control screen XK02.
The

mySQL and PHP search
Hello,
I am trying to code a project and ran into a brick wall with one of my pages. I am pretty

php or sql?
Sorry not sure if this is a sql problem or php the following code is supposed to delete data from th

OOP help
okay so i have a class im making it has everything setup i just need to randomize the 2 variables an

SAP Management Console is blank
Dear All ,

I am facing problem in my des sever suddely in SAP Management Console is blank and

Port scanner problem
Hai
recently i developed one app through which u can check the opened and closed ports under an

How to give the privillege for triggers?
Hi,

How to give the privillage for triggers to particular user?

Please let me

How to make URL loads only on login
On my page, when a user login he's redirects to user_home.php. I made it also to open the chat scree