[Resolved] How to output new dates only?

[eiler]

😕
Hi - about MySQL database.

I need to find a simple way to output the content of my table in a php-build calendar, according to which table-rows have an older event-date than today.

This way I will be able to outsort all the comming events to one part of the calendar (the new) and all the past events can be outputted in another page (the oldies).

Does anyone know how to fix the date-issue? I have build the table with datatype 'date' based on standardvalue '0000-00-00'.

Right now Im only using a simple code like:

mysql_query("SELECT * FROM calendar ORDER by event_date");

I have tried messing with "SELECT * FROM db WHERE, OR, IF"
but it never comes out good...🙁

Thx
Thomas

[barand]

To get the records older than today

SELECT * FROM calendar WHERE event_date < CURDATE() ORDER by event_date

hth

[eiler]

That did the trick.
I was missing the CURDATE. How bout if I want to show things older than yesterday? Will that be CURDATE (minus smt?) ?

Thx for the advice!
Thomas🙂

[barand]

$yesterday = date('Y-m--d' , strtotime('-1 day') );
$sql = "SELECT * FROM calendar WHERE event_date < '$yesterday' ORDER by event_date ";