Neil,
> I appear to be having an error with the following update that I am
> submitting to my database. I am using mysql's DATE_FORMAT function to pull
> the date out and insert in a user friendly form. Upon submission of the
> modified data, I use the below SQL to update the table information.
>
I appear to be having an error with the following update that I am
submitting to my database. I am using mysql's DATE_FORMAT function to pull
the date out and insert in a user friendly form. Upon submission of the
modified data, I use the below SQL to update the table information.
Everything is r
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
# From: Tim Thorburn [mailto:[EMAIL PROTECTED]]
# Sent: Tuesday, May 29, 2001 12:40 PM
# To: [EMAIL PROTECTED]
# Subject: [MySQL] DATE_FORMAT
#
#
# Hi,
#
# I've setup a database to keep track of various events. Now
# I'm working on
# displaying these events on the screen thro
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
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 my database are ISO format, so -MM-DD, I'd
