$array = mysql_fetch_array($query);
$mydate = date("j F, Y",$array[date]);
Change fieldname and the where clause, and that should work.
If you want to further munipulate how it looks, just look at the
date manual page:
And change the first parameter to the date function.
On Mon, 2003-02-03 at 09:09, RUBANOWICZ Lisa wrote:
Hi All, I have a date format of YYYY-MM-DD in MySQL and am showing it on a PHP page. However I want to show it as
"2 February, 2003"
or "2 February"
Can someone please help me. The date will not necessarily be todays date (I looked at the datetime() function and the getdate() function but couldn't work it out for these)
Thanks for your support
All the best
Tel: +353 46 77663
Email: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
-- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://220.127.116.11:8080/adam_at_cryptocomm.asc
Description: This is a digitally signed message part