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

array_combine() error
getting an "Warning: array_combine() [function.array-combine]: Both parameters should have an e

IF STATEMENT HELP
Hi
i have created a calendar from a table:

Code: Calendar: October 2009
<table w

jquery validation in codeIgniter
hai i need to add client side validation to my fiels which are selected in a forloop.the fields are

extract content from a website
i have written a code that will grab the content from the index page..
i would like to know how c

Help with usergroups? prolly really quick
So were coding our own forums for a game system we made an we have the users level setup but now I n

Showing selected item at top of list
Hi,

I've got a list of names which i am fetching from database like this:
$qry = db_query

writing a screen scraper
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses

do while conditions
i want to display 6 images in a 2x3 table
now what would be the correct logic to
count that th

javascript in php code causes page to display white
Hi All,

Odd one this, I've got the following code (below) which is a simple log in form. The

Ariba 9r - SAP MM Integration
Hi experts,

The standard Ariba adapter for 9r creates a relationship between Cost Centers