Re: [PHP-DB] Retrieving date, partially solved

2002-03-02 Thread DL Neil
Ken, If it works, it works! If you want to store the birthdate in a single column in the db, then make the datatype a date in CCYY-MM-DD format, then prepare the query by asking PHP for the server's date as month (MM) and day (DD) and apply those to the query using the functions I pointed you at

[PHP-DB] Retrieving date, partially solved

2002-03-02 Thread Ken Thompson
I have the thing returning the date as long as the date format is "m/d" in the table with a seperate year column. Here's the table: mysql> select * from Cinfo; +-++--+---+---+ | Cid | Fname | Lname| Bday | Byear | +-++--+---+---+ |