Updated value

Anon

Hi all,
I'm creating a product catalog. In the admin area i have a form for adding products to the catalog (database). Everything works just fine but i now want to include a product code for each product. Is there a way of generating a unique value eg. TE001, TE002, TE003 etc. for each product that is inserted into the database and can it be displayed in the form as a readonly text field?

Any ideads on how to go about this would be great.

Thanks,
josh

mistcat

well depending on what database you are using and how you have your table set up, it is easy enough to do. if you are using mysql you have two options, you could simply use the mysql function mysql_insert_id(). This returns the id of the previous insert. Option 2: (which works in other databases too) is to add an autoincrementing integer field in the product table in your database, and then just return that number to the user after the insert. (available via a second select statement). Anyhow what do you think about these solutions?

Anon

You should to add field from AUTO_INCROMENT parameter to table of database. It will be to contain auto-number of position of table, automatically created and enlarged at every addition new element of table of database.

For example :
mysql_query("CREATE TABLE IF NOT EXISTS table_name(Idk INT NOT NULL AUTO_INCREMENT,Kategory CHAR(20) NOT,Name CHAR(20) NOT NULL, NULL,Last_in DATETIME NOT NULL,Number MEDIUMINT DEFAULT '0' NOT NULL,Info CHAR(30) DEFAULT '' NULL, PRIMARY KEY (Idk))");

Field 'Idk' contains number 1, 2, 3 etc..
At read database you should to add text 'TE' to number and you will receive 'TE1', 'TE2', 'TE3' etc. .