I have a database table that is updated via a web form. How do I create a field in the database table that will automatically enter in the date of the entry, to a field, called "Date"....I am using phpMyAdmin?

Either insert it by getting current time using a PHP function like strftime().

Or create a MySQL field (may be of length 14 chars) applying MySQL built-in timestamp function.



`~@#\^%&*/\.<.\/-|+|_!:;..=?>
Students' finances

Thanks for the reply.

I would like to use the option of:
"Creating a MySQL field and applying the built-in timestamp function.

I am working with MySQL via, phpMyAdmin....

I don't know how to set up the time stamp function. Do you have documentation on that?

It is as simple as:
INSERT into table_name(field1, field2) VALUES('$var1', 'timestamp()')

Note that PHP has no function timestamp(). It is of MySQL.

Use phpMyAdmin to easy manage all these things.

`~@#\^%&*/\.<.\/-|+|_!:;..=?>
Students' finances