MySQL Forums
Forum List  »  PHP

Re: Update column when datetime = NOW()
Posted by: Trevor Pan
Date: February 20, 2020 10:37AM

Hi Peter,

Thank you.

Imagine you want a stack of lumber. You post a need for that lumber on a website and give 2 weeks for bidders to review the post and provide a price.

When the two weeks ends e.g.
deadline (column with time stamp) & current time = NOW()

the auction ends.

This causes the status (another column) to go from 0 (false) to 1 (true).

Now, no other bidder can bid on this job.

Hope this clarifies the need...

Options: ReplyQuote


Subject
Written By
Posted
Re: Update column when datetime = NOW()
February 20, 2020 10:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.