[thelist] Displaying Records By Date Later Than Current Date (MySQL + PHP)

[Mike]

At 12:57 20.01.2004 +0000, you wrote:
>Hello all,
>I have a table in my database called "meetings". There are various fields, 
>but the crucial one here is "date".
>This table stores all the meetings that my client is holding or has held. 
>For a "forthcoming meetings" page, I need to display any meetings that 
>have a date later or equal to today's date.

With MySQL's built-in variables you can achieve this with one line of code:

$query = "select * from $dbTable where TO_DAYS( date ) - TO_DAYS( NOW( ) 
) >= 0 order by date";

Mike

_____  mike s. krischker  http://webdesign-schweiz.ch/
        flashpro mailing list  http://flash-list.com/
        royalty free flash sounds  http://flash-sounds.com/