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 d
$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 PROTECT
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
