[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