...

View Full Version : please help limit unix_timestamp by last 7 days



chris666uk1
11-17-2011, 05:37 PM
please could some one help me i need to limit the query by timestamp for the last 7 days here is my code on the php side


<?php

$db = @mysql_connect("localhost", "8conv", "*****") or die("Connection Error: " . mysql_error());
mysql_select_db("tempmonitor") or die("Error connecting to db.");
$sql = "SELECT *, UNIX_TIMESTAMP(datetime) AS datetime FROM 8conv";
$result = mysql_query($sql);
$data = array();
while ($row = mysql_fetch_array($result)) {
$temp1[] = array($row['datetime'] * 1000, (int)$row['temp1']);;

}

$temp1 = json_encode($temp1);

Truffle
11-17-2011, 06:09 PM
I'd say create a variable that holds the timestamp of the soonest date you want to grab.

So something like


$oldest = strtotime( "-1 week" );

Then update your SQL query to read



$sql = "SELECT *, UNIX_TIMESTAMP(datetime) AS datetime FROM 8conv WHERE UNIX_TIMESTAMP(datetime) > {$oldest}";

chris666uk1
11-17-2011, 06:16 PM
thank you so much that got it



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum