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

John C Bullas (soton.ac.uk relay) jcbullas at nildram.co.uk
Tue Jan 20 07:04:24 CST 2004


At 12:57 20/01/2004, Dave Stevens wrote:
>Hello all,
>
>I've run myself round in circles a bit on this one, what I'm trying to do 
>is this:
>
>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.
>
>I've googled this to death, but I must be losing my search technique cos 
>I've yet to solve my problem - can anyone help?
>
>Unix server, PHP page outputting XHTML 1.0, MySQL 4.0.16-Max.

any way to translate the date into a numeric value in a hidden column and 
sort/display on that basis?

2003.<next 2 01 january.....12 month><next two the day 01....31>

2003 Jan 02

2003.0102

2003 March 31

2003.0331

just a thought from "the lists token geologist" ;)


>Any help greatly appreciated :)
>Dave

******************* John C Bullas **************
Homepage: http://www.soton.ac.uk/~johnb/
Blog: http://freeroller.net/page/johnbullas/Weblog
**** Eudora Mail 6.0.0.22  + McAfee Virus Scan 4.5.1 ****



More information about the thelist mailing list