Re: [PHP] help with date formatting

2002-03-18 Thread mnc
On Mon, 18 Mar 2002, Ryan wrote: > Hi, I'm trying to create an events page, where it shows the posted > events. I enter data using phpmyadmin. Currently, the ouput is like > this: > > 2002-03-06 > > I'm having trouble with the formatting of the date. I'm using the type > date with the functio

Re: [PHP] help with date formatting

2002-03-18 Thread Ben Edwards
I use string manipulation on the date, basically split it into $day, $month and $year and use this to product formatted output. Ben At 17:51 18/03/2002, Ryan wrote: >Hi, I'm trying to create an events page, where it shows the posted >events. I enter data using phpmyadmin. Currently, the oupu

Re: [PHP] help with date formatting

2002-03-18 Thread Mark Heintz PHP Mailing Lists
Since you're using phpmyadmin, I'm assuming you're using mysql. You could use the built-in date and time functions to do the formatting when selecting your date field. Check here: http://www.mysql.com/doc/D/a/Date_and_time_functions.html mh. On Mon, 18 Mar 2002, Ryan wrote: > Hi, I'm trying

[PHP] help with date formatting

2002-03-18 Thread Ryan
Hi, I'm trying to create an events page, where it shows the posted events. I enter data using phpmyadmin. Currently, the ouput is like this: Conference in New York 2002-03-06 There is going to be a conference in New York next week. -

Re: [PHP] help with date formatting

2002-03-06 Thread Anas Mughal
Sure, you could do something like: $event_month = substr($event_row["Date"], 5, 2); $event_day = substr($event_row["Date"], 8, 2); $event_year = substr($event_row["Date"], 0, 4); $msgBody = "Date: " . date("l", mktime(0,0,0,$event_month, $event_day, $event_year)) . ", " . date("F",

[PHP] help with date formatting

2002-03-06 Thread Ryan
Hi, I'm trying to create an events page, where it shows the posted events. I enter data using phpmyadmin. Currently, the ouput is like this: Conference in New York 2002-03-06 There is going to be a conference in New York next week. -