I'm no expert, but here's what I did in the same situation.
$enterdate = date('Ymd'); --- this gives me the current date.
then when entering the information from the form into my database I just
entered the variable into a field called evdt
When using the date I wanted it in a more user friendly state (also UK
format) I did this:
$query = ' SELECT DATE_FORMAT(eventdate, "%D %M %Y")as evdt FROM notices';
This gives me it in the format "1st December 2002".
"David Jackson" <[EMAIL PROTECTED]> wrote in message
> Howdy --
> I'm my trying to insert to current date from a php form? I know that
> MySQL has a CURDATE() fucntion and PHP has several date function, but I
> cann't seem to get either to work? Here is my existing code:
> David Jackson
> ---------- client_add.php --------
> <?php require('connect.php'); ?>
> mysql_query ("INSERT INTO client (cl_add_date,
> VALUES ('$_POST[ADDDATE]',
> '$_POST[cl_web]') ");
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php