Working out when a week is?

On my site there is a table for weekly views, but it needs to be reset each week. I don't want to do it manualy every week and my server doesn't support cron (I think thats what its called).

So is there any way to detect if its been a week since the table rows have been reset back to 0?

Why not just do it with MySQL, and then use MySQL Datetime and query like

PHP Code:

---

<?php
$one_week_ago = date('Y-m-d H:i:s', time()-(60*50*24*7));
$now = date('Y-m-d H:i:s');
$query = mysql_query("SELECT SUM(`views`) AS `viewsThisWeek` FROM `views` WHERE `date` BETWEEN '{$one_week_ago}' AND '{$now}'");
// insert a row on view for more detailed information, such as peak times etc
echo 'Views this week' . $query['viewsThisWeek'];
//untested 
?>

---

*removed*

Edited by Invent (Forum Moderator): Please don't be rude.

Stop bringing arguments into threads! I could yawn and it would be more controversial on this forum than McCain.

Quote:

---

Originally Posted by Hypertext

Why not just do it with MySQL, and then use MySQL Datetime and query like

PHP Code:

---

<?php
$one_week_ago = date('Y-m-d H:i:s', time()-(60*50*24*7));
$now = date('Y-m-d H:i:s');
$query = mysql_query("SELECT SUM(`views`) AS `viewsThisWeek` FROM `views` WHERE `date` BETWEEN '{$one_week_ago}' AND '{$now}'");
// insert a row on view for more detailed information, such as peak times etc
echo 'Views this week' . $query['viewsThisWeek'];
//untested 
?>

---

---

Can you not read, seriously?

PHP Code:

---

$query = mysql_num_rows( mysql_query( 'SELECT `time` FROM `weekviews` WHERE `time` <= \'' . time() - 604800 . '\'' ) );
if( $query !== 0 )
{
    mysql_query( 'TRUNCATE TABLE `weekviews`' );
} 


---

You'll need a time field on the table, either use time() in php or just UNIX_TIMESTAMP() in mysql

I was just giving him a better way to do stats... I don't know why you wouldn't want more info than a count, and I definitely don't know why you'd want to destroy valuable data.. such as statistics.

Ive found a way arround it now, my table was like

|--PAGE ID---|--VIEWS--|---VIEWSINWEEK--|
|----1-------|---288----|------48-----------|
|----2-------|---234----|------15-----------|

So I have just added a text file which has the last time() that the views col was emptyed. Then when a page is viewed it checks to see if its over 1 week.

Thanks for you help anyway.