I'd say I'm a newbie to PHP and MySQL, and am looking for a solution to this problem! I have to create an auction site for my coursework, and I'm trying to make auctions that expire.. well.. expire. I have 'Expires' and 'Starts' stored in my SQL table, obviously. I want to make sure on the home page, only auctions that have not expired are displayed - as you can see, this, at the moment is not the case. To add the 'Expires' value to a product, I used this MySQL code: and here is my homepage script: any help to how to tackle this would be appreciated, I'm having a real hard time!