automatic upadate???

[ah66533]

Hi there!

I'm making some kind of auction system.
Does anybody know that is there anyway to insert a row into a table that will be automatically removed after or at a certain time?

<b>example:</b>
If user sell his item at auction and the item is open for example 3 days....is it possible to delete/update that data at database automatically?

[Anon]

Add a field for the time the record was added into the auction database.. then in your index run some sql that checks if the date field in the db is < current time - 3 days ... (u could either do it for everyvisitor or set a unix crontab to do it once a day...

[Anon]

i think u better have a field called status in ur table
defalut to 1

i mean when auction is live let the field be 1 and as soon as the auction is complete make it 0 on update

else u use some sql interval functions

as select date_Add(curtime() + interval 3 days)

i use mysql u check as per ur db

cheers
[e-mail]