automatic update

[Anon]

Hi there!

I'm making some kind of auction system. Is it possible to update mysql table automatically?

I have table field named "status". and when auction is open status value is 1 and when auction is closed value is 0. is it possible to update that field automatically?

[[deleted]]

Nothing ever happens automatically.
You'll have to decide when the status should become '1' and when it should be '0'

[ah66533]

I have also fields name start_date and end_date. Start_date holds value when the auction is started and end_date is the day when auction stops (usually after 14 days)

[miasma]

One trick is to check you database everytime someone hits the page to do a little update (some people use this for cleanup of data.. like putting a timestamp on shopping carts and the next time someone makes a request tot he shopping cart table it deletes all carts over 6 hours old)...

The other suggestion I have is (depending on what OS yer running on) is setup a cronjob to take care of all auctions every hour or so

[zkent]

When someone accesses the auction page to display the current auctions, your script must me querying the database for auctions listed there, right? Well, when the script queries, do something like this:

SELECT *
FROM auctions
WHERE end_date < today()

NOTE I have not tested this, but the premise is that you can test the validity of the auction in real-time based on the current date.