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