SQL question

[Quantz]

I have a question about a mysql query im having trouble with... Is it possible to select from a table for example

Code: [Select]

SELECT * FROM table_a WHERE timestamp<=timestamp+43200"
What I'm trying to do is check for any rows in a table that are 5 days or less old but I'm not sure if mysql lets you do this.

my actual code is here,

Code: [Select]

mysql_query("SELECT * FROM friendly_challenges WHERE challenger='$team_a[id]' AND accept='No' AND timestamp<=timestamp+432000");
Anyways, would appreciate any advice. I know a longer way to code around this, I would just like to know if there is syntax to actually do it like this.

Cheers,
Doug

[Nox]

For "or less" you need > not <

if you have a datime column then you can do

Code: [Select]

WHERE created > NOW() - INTERVAL 5 DAY
for timestamp, yes, something like than should work

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

[Quantz]

heh, i figured it out

Code: [Select]

$fiveDays = $now-432000;
mysql_query("SELECT * FROM friendly_challenges WHERE challenger='$team_a[id]' AND accept='No' AND timestamp>='$fiveDays'");
that did the trick, thanks for helping me out!!!