raghav472 — 2013-07-01T06:36:50-04:00 — #1
I am new to php.
I have a record in my database, when i change the record and update, the modified date should automatically get insert into database.
what are all the steps i need to take?
spikez — 2013-07-01T06:41:34-04:00 — #2
Use NOW() in your Update statement
field1 = 'value1'
, field2 = 'value2'
, datefield = NOW()
raghav472 — 2013-07-01T06:59:48-04:00 — #3
thank you so much..
system — 2013-07-05T08:22:41-04:00 — #4
I am also agree.Now() will be used in the update query to display the current date and time.It returns the yyyy-mm-dd and also HH:MI:SS.