Re: Date formatting Question (Beginner)

> I've a date stored in a MySQL table. > When retrieving this date from the DB, I want to output this date in day, > Month Name, Year format. > > I've tried numerous variants of the following code: > $date = $row["task_date"]; > print (date ("d F Y", $date)); You know, when you ask a question like this on a mailing list of thousands, you'll get a thousand different answers. :) You could let MySQL do the work for you: select monthname(task_date) as month, dayofmonth(task_date) as date, year(task_date) as year from .... then when fetching your array, use: $month = $row['month']; $date = $row['date']; $year = $row['year]; There are tons of MySQL date/time related functions that can make lives easier...it's in section 7.4 or soemthing like that. - Julie +------------------------------------------------+ | Julie Meloni | | Tech. Director, i2i Interactive (www.i2ii.com) | | e-mail: jcm@i2ii.com | | | | "PHP Essentials" ... http://www.thickbook.com/ | +------------------------------------------------+