aliento Posted January 6, 2010 Share Posted January 6, 2010 I make an auction site, i want to see if any auction has expired and if it ends set the `status` entry to 'closed' . I use Unix timestamps saved to the `auctions` table. This table has and one field `staus` which has to change if the field `published_time` have expired. Any help ? My thought was to ask db which have expired save the ids to an array and then make the update . But this is very expensive i hope there is a juggling which do it at once. Quote Link to comment Share on other sites More sharing options...
whansen02 Posted January 7, 2010 Share Posted January 7, 2010 update set status = closed where (published_time > allowed_time) Or something to that affect. If you design your database layout right it's not a very costly query. And really you shouldn't have to worry about that too much unless this auction site was super sized. Quote Link to comment Share on other sites More sharing options...
aliento Posted January 7, 2010 Author Share Posted January 7, 2010 no it is not so big but i want to design it ... I will try it tomorrow , thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.