This is Interesting: Free Magazines for Graphics designers and webmasters  


Home > Archive > Dreamweaver > March 2004 > current date





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author current date
tgwarrior

2004-03-09, 12:30 pm

I'm using Dreamweaver MX 2004 with PHP/MySQL.

I have an insert record form connected to a database that contains a date
field (which is not displayed on the form for users to enter a date). The date
field is a hidden field on the form. I would like today's date to be added to
the database record when the user submits the form. Can this be done?

David Powers

2004-03-09, 12:30 pm

"tgwarrior" wrote...
> I'm using Dreamweaver MX 2004 with PHP/MySQL.
>
> I have an insert record form connected to a database that contains a date
> field (which is not displayed on the form for users to enter a date). The

date
> field is a hidden field on the form. I would like today's date to be

added to
> the database record when the user submits the form. Can this be done?


You don't need a hidden field. Just use CURDATE() in your SQL query as the
value to be entered in the relevant column in the database.

--
David Powers
*******************************************
Co-author, "Foundation Dreamweaver MX 2004" (friends of ED)
http://computerbookshelf.com/foundationdw.php


Sponsored Links


Copyright 2003 - 2008 forum4designers.com  Software forum  Computer Hardware reviews