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

xml element exists
Code: [Select]<?xml version="1.0"?>
<Addresses>
<

Locking mysql tables with php
Hi

BACKGROUND:
I have multiple instances of the same php script running in a WAMP environ

PHP Function Page Advice
Hi All, I am quite new to PHP and Javascript but have written an Online Shop (Mainly for Fun and edu

Filename and Line Number Custom Error
I have a class, with a method that accepts 2 parameters. I would like to output error messages.

b+ tree
Hi
can every body help me about b+ tree ?(insert & delete)

Legal Issues for SAP ERP o ERP in general
Hi experts,

Can someone please help me finding some documentation about legal issues tha

Display Database
I need to create a shopping cart. I found this code online: http://conceptlogic.com/jcart/
Unfort

A little help in c#
i am doing a simple paint program using c# i want to draw with the mouse so i wrote the code of the

Table sorting
Hi,

I'm trying to modify the following in order to make the output table sorted alphabeticall

True way to see if action was successful?
If this is a good way to see if action was successful to continue:

Code: function changeGa