We have a PHP based website (using osCommerce) selling mobile phones, based on a MySQL database.
We also sell mobile phone accessories, and want to have a page which lists justs these. Only some accessories are compatible with a particular phone, so the association between the phone and accessory has to be set up in the Admin part of the website.
In addition, the customer might want to buy an accessory, and not a phone. Thus an accessory is a product in it's own right. However, the accessories shouldn't appear in the listings of the phones on the website, so a way of distinguishing accessories from phones needs to be made.
A short description of each accessory needs to be inputted in the Admin part of the website.