timestamp comparison

[witold]

hi,

in my DB dates are written in timestamp format. i thought it would be easier to retrieve data from before a week, fortnight or a month. unfortunately, i got stuck and can't even make a simple comparison without generating an error message. here's my code.

---

e.g. need to get data from before a week untill now

newdate == date("Ymdhis") - 7; //trying to get a timestamp format

$sql= "SELECT * FROM offers WHERE date > $newdate";
$sql_job = mysql_query($sql,$connection);
while ($row = mysql_fetch_array($sql_job)) {
$id = $row["id"];
$date = $row["date"];
echo $id . " " . $date . "<br>";

}

any help on how to do this will be appreciated.

witold

[planetsim]

Okay firstly this

newdate

should be this

$newdate

Secondly id prefer to use INT as the time feild in a Database than all i need to use is time() to validate it.

Id suggest changing that in the database and in the script.

[mrhappiness]

if you convert timestamp to datetime you can use something like this

SELECT id
FROM tablename
WHERE (datecolumn + INTERVAL 7 DAY) >= NOW()

and you get everything from the past 7 days

[witold]

thanx, this one suits me best and its syntax is clear to me.

btw, i didn't know the 'interval' function before, so thanx for that too. can you give me a link where i could read more about it?

regards,

witold