Bidding system with PHP and MySQL

[gregson09]

Hello there,

I have a number of products which I would like to auction off on my site. I would like to get it so that when a customer clicks on a product, they are given the oppurtunity to make a bid for it, right up until the last minute of the auction. I have some PHP and MySQL experience, but is it appropriate to design a script that retrieves the current high bid from a database and allows the customer to enter their email address and a new bid? The script then simply checks if the bid is higher, and if so, sets the new high bid and email address of the new high bidder. What about multiple people trying to bid at the same time - would it be stable (for example, in the last few minutes of the auction)?

Or is this something I should rather find a pre-made script to do?

Thanks for your time and help!

[SeanieC]

Script yourself I suggest. Atleast that way you can customise the script to your liking, plus I don't think there would be that many scripts in this field. I to am thinking of using the same technique on my website (not for a little while). But I will be scripting it myself. I am guessing that if two users made a bid at the same time then you should use a delay before it declares who the highest bidder is and a statement telling users that there is a delay of say 2 seconds. But thats just a guess. ;)