Hello everybody.
There is a row in my db table I have set it's type as "TIMESTAMP". How should I fill in?
Should get the current timestamp in php and send it to that row, correct?
So how can I do that?

Recommended Answers

All 5 Replies

Well, I still haven't got what to do exactly. Where should I put CURRENT_TIMESTAMP() in the script? I'm using PDO.
Would you please help me more?

in your database (phpadmin for example) use default current_timestamp and in attribute on update current_timestamp

UPDATE mytable SET timestamp_field = CURRENT_TIMESTAMP()

I understood. Thanks friends.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.