e-commerce

[Anon]

I'm setting up a small e-commerce site using PHP and MySQL and I'm trying to write code that once someone purchases an item, that item is no longer available to other customers. I don't want it removed from the database, I'd rather have a "sold" message appear in place of the "buy now" button or something similar.

Does anyone have an idea how I should go about this, what the function is that I would use?

[Anon]

By the way, I'm builing this on Win98 using an Apache server.

[Anon]

I'd just have a "sold" field in the database for each item. When it's sold, an "S" could just be inserted in that field. Then you could just say... If sold == s then echo sold.

[Anon]

make a field in the database on whether it is instock or sold

if instock=Y then show it if not then dont,
or only query if instock=Y