please help limit unix_timestamp by last 7 days

[chris666uk1]

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);

[The Little Guy]

SELECT *, UNIX_TIMESTAMP(datetime) AS datetime FROM 8conv where datetime > date_sub(now(), interval 7 day)

[xyph]

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html