Getting result which are not 30 days old

[Anon]

How do I do that?
Maybe not 30 days, maybe even a year...
Do I use mktime even?
I'd just like to hear some suggestions...

Thanks, Arni

[[deleted]]

I guess you mean "how do I select records from a database that have a date field containing a date of not more than 30 days ago"
in mysql:

SELECT * FROM mytable WHERE date_field>date_sub(now(),interval 30 day);

the "day" is not a typo, it has to be singular.

Check out the MySQL manual for more information about dates and date caculations.

[Anon]

Thanks dude :]

[Anon]

Should the datefield be datetime?
Or something else?

[Anon]

me be stupid =)

[Anon]

I've tryed your method, as well some at
http://www.mysql.com/documentation/mysql/commented/manual.php?section=Date_and_time_functions but nothing seems to work... 🙁

I don't get any error, using mysql_errno, I just don't get any results..

[[deleted]]

What's the query you use?

[Anon]

I'm at home now, so...
It kinda goes like this:

$sql = "SELECT * FROM table "
if (stuff) {
$sql .= "WHERE something = '$something' ";
}
$sql .= "date_field>date_sub(now(),interval 30 day) ORDER BY name";

And I echo the $sql everytime I query it.
And can't I do date_sub(CURDATE()...) instead of NOW().