what would be the best practice of inserting a timestamp in a mysql.
I want to use this timestamp so that I can call out the articles:
The most recently added... displayed first.
why don't you use a DATETIME field ? ?
if you read my question, it said what is the best way of inserting it into the database ....not which data type is best to use!
I think an article system is not that suitable for using advantages of timestamp. You know, timestamp is an auto self-update type which sounds to be good for insert operations. But when you update the row the timestamp will update itself and it seems like article was added when it updated.. I think timestamp will be very useful when you use same database for seperate applications.Sometimes different applications need to learn which rows are updated out of the application from a certain time.. That time timestamp is very useful since it provides you recognize which rows are updated from a certain time...
its for my intranet system @ work - I want the article to show up first, even if it has been edited or added. @ Wien said I should rather go for the datetime . Are you saying I should do the same?
Yes my friend. Rather than an auto-update type...
