Mysql Date Problem

[Scorpio_Boy]

Hi, I am trying to get the date from a MYSQL server into a PHP page I am
creating with Dreamweaver, I create a new recordset and go to advanced and
enter the following query SELECT CURDATE() if I click test it returns the
current date correctly, however as soon as I close the window the recordset
displays MM_ERROR 1064 SQL Syntax Error and stops working. I am sure this is
something really simple, what? Also the date is returned as Year-Month-Day ,
can I change that to Day-Month-Year with + something?

[David Powers]

Scorpio_Boy wrote:

> Hi, I am trying to get the date from a MYSQL server into a PHP page I am
> creating with Dreamweaver, I create a new recordset and go to advanced and
> enter the following query SELECT CURDATE() if I click test it returns the
> current date correctly, however as soon as I close the window the recordset
> displays MM_ERROR 1064 SQL Syntax Error and stops working. I am sure this is
> something really simple, what? Also the date is returned as Year-Month-Day ,
> can I change that to Day-Month-Year with + something?

I don't know why Dreamweaver does that, but it's rather pointless using
MySQL to display the current date. PHP does that for you with the
greatest of ease, and in the order you want:

<?php echo date('d-m-Y'); ?>

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[Scorpio_Boy]

Thank you for the response, i know I can get the info from php, but i
particularly want to use a mysql query so that i can display the info within a
form and then use it as part of a record that gets submitted back into the
database. I have made other custom recordsets work in the past and I'm really
trying to find the reason why this one won't work...

[David Powers]

Scorpio_Boy wrote:

> Thank you for the response, i know I can get the info from php, but i
> particularly want to use a mysql query so that i can display the info within a
> form and then use it as part of a record that gets submitted back into the
> database.

The problem with trying to do that is that your date will still be in
the wrong format for MySQL. Why not just amend your insert statement to
set your date column as CURDATE()?

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]