Hi Tim!
You could do something like this:
$sqlstr = select date_format(EventStartDate, '%M %D %Y') as mydate, (rest of your
SQL string here) ;
$result = mysql(mydb, $sqlstr, $connect) ;
$myformatteddate = mysql_result($result, 0, 'mydate') ;
This should do it for you :) HTH
$Result = @mysql_query (SELECT DATE_FORMAT(EventStartDate,'%M %D %Y') AS
EventStartDate FROM EventsTable);
$Row = mysql_fetch_array($Result);
printf(Event Date:%s, %Row['EventStartDate'];
Hope this helps :o)
--Patrick
# -Original Message-
# From: Tim Thorburn [mailto:[EMAIL
At 2:39 PM -0500 5/29/01, Tim Thorburn wrote:
Hi,
I've setup a database to keep track of various events. Now I'm
working on displaying these events on the screen through a web
browser. I've got all the crucial information displaying - now its
time for a little fine tuning.
All the dates in