On Sunday 17 November 2002 18:31, Ray Healy \(Data Net Services\) wrote: > The startdate and endate columns are "date" format - have any ideas what i > can do
..."This seems to work BUT if the date in the database is a single number i.e. 0 to 9 it cannot dispaly it and also if the startdate or endate is a 10, 20 or 30 it also thinks that it is a 1, 2or 3"... I'm not sure what you mean by "if the date in the database is a single number". DATE columns in MySQL are in this format 'YYYY-MM-DD', so where is the single digit coming from? Anyway could you show a few sample entries from your table? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* I dote on his very absence. -- William Shakespeare, "The Merchant of Venice" */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php