RE: [PHP-DB] Displaying Date from Value in MySQL DB
Add an AS to your statement ... ditoevents.eventdate,DATE_FORMAT(ditoevents.eventdate, '%a, %b %d %Y') AS eventdateformatted, ditoevents.eventtime ... then $row[eventdateformatted] should contain the date in the way you want it. -Mike -Original Message- From: Tyler Replogle [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 5:36 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Displaying Date from Value in MySQL DB You could always make your own function. If you need help with that i would be glad to help there too. >From: "Justin @ Dreaming in TO" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: [PHP-DB] Displaying Date from Value in MySQL DB >Date: Tue, 20 Apr 2004 14:27:30 -0400 > >Hey All, > >Looking to try to figure at small problem. > >This is the SQL query I am using to show the next event on a page: > >SELECT ditoevents.eventstatus, ditoevents.eventdate, >DATE_FORMAT(ditoevents.eventdate, '%a, %b %d %Y'), ditoevents.eventtime, >ditoevents.eventlocation, ditoevents.topic, ditoevents.presenter >FROM ditoevents >WHERE ditoevents.eventstatus = 'next' > >This is the structure of the table in the MySQL db: > >CREATE TABLE ditoevents ( > ID char(3) NOT NULL default '', > eventID char(2) NOT NULL default '', > eventstatus varchar(4) NOT NULL default '', > eventdate date NOT NULL default '-00-00', > eventtime time NOT NULL default '00:00:00', > eventlocation text NOT NULL, > topic text NOT NULL, > presenter text NOT NULL >) TYPE=MyISAM; > >The problem is, the date value that's being pulled from the DB is being >displayed as 2004-05-12. I would like the date to be displayed as, >Wednesday, May 12th, 2004. > >How do I do this with PHP. I looked at some of the date functions, and I'm >a bit confused. > >Thanks, > >Justin > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > _ Stop worrying about overloading your inbox - get MSN Hotmail Extra Storage! http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm00200362 ave/direct/01/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Displaying Date from Value in MySQL DB
In PHP you could do something like: $mydate = date("l, F jS, Y", strtotime($row["eventdate"])); echo $mydate; http://us4.php.net/manual/en/function.date.php gives a full listing of possible formatting options. --Nicole --- Nicole Swan Web Programming Specialist Carroll College CCIT (406)447-4310 -Original Message- From: Justin @ Dreaming in TO [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 12:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Displaying Date from Value in MySQL DB Hey All, Looking to try to figure at small problem. This is the SQL query I am using to show the next event on a page: SELECT ditoevents.eventstatus, ditoevents.eventdate, DATE_FORMAT(ditoevents.eventdate, '%a, %b %d %Y'), ditoevents.eventtime, ditoevents.eventlocation, ditoevents.topic, ditoevents.presenter FROM ditoevents WHERE ditoevents.eventstatus = 'next' This is the structure of the table in the MySQL db: CREATE TABLE ditoevents ( ID char(3) NOT NULL default '', eventID char(2) NOT NULL default '', eventstatus varchar(4) NOT NULL default '', eventdate date NOT NULL default '-00-00', eventtime time NOT NULL default '00:00:00', eventlocation text NOT NULL, topic text NOT NULL, presenter text NOT NULL ) TYPE=MyISAM; The problem is, the date value that's being pulled from the DB is being displayed as 2004-05-12. I would like the date to be displayed as, Wednesday, May 12th, 2004. How do I do this with PHP. I looked at some of the date functions, and I'm a bit confused. Thanks, Justin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Displaying Date from Value in MySQL DB
You could always make your own function. If you need help with that i would be glad to help there too. From: "Justin @ Dreaming in TO" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] Displaying Date from Value in MySQL DB Date: Tue, 20 Apr 2004 14:27:30 -0400 Hey All, Looking to try to figure at small problem. This is the SQL query I am using to show the next event on a page: SELECT ditoevents.eventstatus, ditoevents.eventdate, DATE_FORMAT(ditoevents.eventdate, '%a, %b %d %Y'), ditoevents.eventtime, ditoevents.eventlocation, ditoevents.topic, ditoevents.presenter FROM ditoevents WHERE ditoevents.eventstatus = 'next' This is the structure of the table in the MySQL db: CREATE TABLE ditoevents ( ID char(3) NOT NULL default '', eventID char(2) NOT NULL default '', eventstatus varchar(4) NOT NULL default '', eventdate date NOT NULL default '-00-00', eventtime time NOT NULL default '00:00:00', eventlocation text NOT NULL, topic text NOT NULL, presenter text NOT NULL ) TYPE=MyISAM; The problem is, the date value that's being pulled from the DB is being displayed as 2004-05-12. I would like the date to be displayed as, Wednesday, May 12th, 2004. How do I do this with PHP. I looked at some of the date functions, and I'm a bit confused. Thanks, Justin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Stop worrying about overloading your inbox - get MSN Hotmail Extra Storage! http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm00200362ave/direct/01/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Displaying Date from Value in MySQL DB
From: "Justin @ Dreaming in TO" <[EMAIL PROTECTED]> > SELECT ditoevents.eventstatus, ditoevents.eventdate, > DATE_FORMAT(ditoevents.eventdate, '%a, %b %d %Y'), ditoevents.eventtime, > ditoevents.eventlocation, ditoevents.topic, ditoevents.presenter > FROM ditoevents > WHERE ditoevents.eventstatus = 'next' Use an alias: SELECT ditoevents.eventstatus, ditoevents.eventdate, DATE_FORMAT(ditoevents.eventdate, '%a, %b %d %Y') AS myformatteddate, ditoevents.eventtime, ditoevents.eventlocation, ditoevents.topic, ditoevents.presenter FROM ditoevents WHERE ditoevents.eventstatus = 'next' Then display $row['myformatteddate'] when you're displaying the data. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php