PHPMYADMIN & PHP Help
Posted: Fri Feb 04, 2011 10:48 am
I'm Currently writing a program for a Shop to use as Online Ordering System.
It involves it being used at a wholesalers so that admin's in the shop can see what is being purchased.
The program runs off a PHPMYADMIN Database 'Products', It is common at the wholesalers to buy a certain product from more than one supplier, to overcome this, I have added a feature on the UI for the User to temporarily add a new product in, in this instance a second purchase of the same product from a different from.
The Problem I am having is that the Database is not allow duplicate Product names to be entered in, therefore a second sale cannot be filled in.
Does anyone know how to give each product a unique identifier, for example a number, so that the table can accept duplicate names of products.
Thank You
It involves it being used at a wholesalers so that admin's in the shop can see what is being purchased.
The program runs off a PHPMYADMIN Database 'Products', It is common at the wholesalers to buy a certain product from more than one supplier, to overcome this, I have added a feature on the UI for the User to temporarily add a new product in, in this instance a second purchase of the same product from a different from.
The Problem I am having is that the Database is not allow duplicate Product names to be entered in, therefore a second sale cannot be filled in.
Does anyone know how to give each product a unique identifier, for example a number, so that the table can accept duplicate names of products.
Thank You