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
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
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
]]
# 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 through a web browser.
# I've got all
# the crucial information
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