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

2 decima places & How to reload my page
Hello There,

How do i put full-stop (.) after second figure from behind? ie if i have 123456

PHP Upload issue
Hi guys,

I have stumble across an interesting issue with my script and is doing my head in.

Problem with shopcart code
Hello, I am having a bit of trouble being able to add a product to my shopcart. My mysql database i

Stumped by Third Day of Month problem
I am trying to build an algorithm that will essentially do this:
Code: [Select]$this_month = Oct

Bluetooth RSSI & VIsta
Okie I got 4 Bluetooth adapters, a DBT-120 by Dlink, A Zonet Microsoft Bluetooth which is what I use

Not loading image
When this function gets loaded it doesn't load the image just trying to figure out why.

Code:

SQL Injection
In my attempts to protect my database from mySQL injection I have created another problem for myself

Form validation with functions
Hi there

I am trying to make a very simple form validation function. I currently have the fol

php multiple action on submit
I have a form which says:

<form enctype='multipart/form-data' method='post' action='pr

validating url
im trying to validate url's sent to me by a form
the url's im collecting are for placing banners