[zorn]

I'm trying to convert an ASP/Access tutorial to PHP/MySQL and have a question regarding MySQL.

In Access one can create a date field and set the default to "Date()" to get the current date but according to the mysql manual:

http://www.mysql.com/doc/en/CREATE_TABLE.html

Default values must be constants. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE.

Is there any other way to have MySQL automate this? I've heard of something called stored procedures but am unfamiliar. -- Must this be done on the scripting side?

Thanks.

[timster]

Not sure what you're aiming to do, but if you want the current date to be placed in the field when the record is created then you just need to add the now() function to the SQL query that creates the row.

For instance something like this:

INSERT INTO table (name, date) VALUES ("name", now());


Then whenever a new record is created, it'll have the current date in the date field.

-tim