e-commerce problem

[scythian]

I'm setting up a small e-commerce site using PHP and MySQL on Win98 using Apache 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?

 

[SteveBrett]

why not have an extra field in the database and then modify the script that pulls out the details ... ?

e.g have a 'sold' attribute in your table and set it 1 or whatever when the item is sold and then display your 'for sale' or 'sold' graphic on the value of that attribute when you pull out the items for display in your page ...

Steve

 

[scythian]

thanks Steve. sounds good.

 

[rycamor]

I hesitate to say this... but are you aware of the *many* possible security problems with using Win98 for e-commerce?

I hope you are just using it as a development server, not as the place where people actually make purchases and enter credit card numbers.

I'm not saying the server has to be Linux, or FreeBSD, but at least use NT. (even that's got problems). and you should really consider using Apache-SSL, instead of just straight Apache.