date problem

I want to display dates in a calender after today

[bono667]

I want to display dates in a calender after today.

in other words something like

SELECT * FROM calender WHERE date >= $today order by date asc

I just want to select all dates that come after todays date, I can get todays date but cant work this out.

Oh, and does ne1 know how to make the date into an english style date too? eg 06/09/2003 instead of 2003/09/06

[mcc235]

SELECT DATE_FORMAT(date,'%d/%m/%Y') FROM calender WHERE date >= NOW() ORDER BY date ASC;

See the manual [mysql.com] for more info.

[jatar_k]

by the way

Welcome to WebmasterWorld bono667

[bono667]

thanks i found anouther post which explained all, but thanks for the help ne how

[mcc235]

bono667 what didn't you understand about the sql statement above? It does exactly what you asked for, selects all dates after today in the english format. Why did you need another post? Was there some other information that you also wanted, or didn't you understand the sql statement? It will help me to understand, for the next time I try and help someone.

[Afkamm]

Do you need to add ASC at the end of the SQL statement?

Doesn't the output ascend automatically when it's not there? or is this just a case of keeping the code 'neat'?

Ta

Marc :-)

[bono667]

I found the post before your reply thats the reason i didnt need the help. Thankyou anyway.:-)

[killroy]

If you need a raw list of dates, rather then selectign records from a table based on their dates, you need a pivot table.

SN