[SOLVED] What do you us whenever you need to assign a modified time/date stamp to a mysql

[mm00re]

Where would be a good source for this kind of information as I have not really found anything specific to this that was somewhat easily explained.

[carlos1234]

Not sure what you are asking.  Can you rephrase the question? 

 

Carlos

[ToonMariner]

I normally use a query to do that kind of thing.

[mm00re]

well I thought it was simple but I have a record in my database that I want to reflect modification date and time, I have a field called LastMod, anytime I modify a record this field is updated along with the rest of the fields in the update script to show when something was modified.

[carlos1234]

Okay...well it sounds like you have what you need then...

[mm00re]

not exactly

 

I am trying to find out if there is a php function that will give a date and timestamp that I could pass to my "UPDATE" script

[carlos1234]

If you create a DATETIME file in a mysql table it is my understanding that this field is automatically updated whenever a change is made to the record that contains that field.  So really, if that is the case...you do not need a PHP function to give you the proper date and time.  Just create a field and make it of type DATETIME and then make a chance to the record and see if that field is updated automatically. 

 

Carlos

[roopurt18]

This type of logic is better left in the database and left out of PHP altogether.  If you read the MySQL documentation on the DATETIME and TIMESTAMP data types you'll find the information you need.

[ToonMariner]

hint: NOW()

[mm00re]

ok thanks guys I'll check into it