Monday, March 6, 2006, pittlimey wrote:
> Am very new to php and mysql, I am trying to use a button on my web
> page to get the current time and then I want to write it to a field on
> my web page, add more data to other fields via the keyboard and
> finally write all the fields to the mysql database. I created the
> input fields using appgini, and now I need this additional function.
---
If you can get away with not displaying the current date and time
while the user is inputting data, you can use the following in your
SQL:
CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, NOW(), and SYSDATE()
to insert the date and time into the record you are inserting or
updating.
HTH,
--
Geoff Lane
Cornwall, UK
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
