[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-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

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 ouput

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 function now,

[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.

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,