PDA

View Full Version : capture the date in a database


m1a2x3x7
05-13-2007, 02:19 AM
Hey everyone,

I want I've created a blog and if someone leaves me a comment i want it to post the date that they sent it, without them having to type it in themselves.

As Iím writing this Iíve thought of an idea but not sure. when you go to my blog site it post the date, if i set this date to a variable and set it to be sent to the database as a date field say a varchar would that work correctly?

Or whatís the best way to do this?

Thanks

davidj
05-13-2007, 08:11 AM
what scripting language and database you using?

m1a2x3x7
05-13-2007, 02:20 PM
sorry...php and mysql

davidj
05-13-2007, 07:29 PM
post the code you have

the SQL insert statement