help with mysql queries and dates...

[acidglitter]

How can I only show things from a table that are at least one month old? The row or whatever that shows the dates is the "date" type

[willfitch]

SELECT * FROM table WHERE date_field > CURDATE()

[acidglitter]

hmm I tried that but it didn't work :(

[redarrow]

SELECT something FROM tbl_name WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY)

[acidglitter]

So I tried that and I changed everything except for
WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY)

Instead of limiting what it showed to things that are at least a month old, it just showed EvEryThiNG :(

[acidglitter]

[size=6pt]*bump*[/size]

[HeyRay2]

[b]redarrow[/b]'s example, from [url=http://www.mysql.org/doc/refman/4.1/en/date-and-time-functions.html]MySQL.org[/url], is missing a comparison. Otherwise, it should work fine. Try this:

[code]
<?php

$query = "SELECT something FROM tbl_name WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col";

?>
[/code]

[acidglitter]

gr this is irritating..

So it looks like this now
[code]$sql=mysql_query("SELECT * FROM losers WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= lastused");[/code]

Maybe I should just select everything and then put LIMIT TO something..?