CODEWITHSUNDEEP
phpmysql
user140291
user140291

Reputation:

MySQL insert to multiple tables (relational)

tbl_product
Name | Creator | UID | Salerank

tbl_price
Supplier | Price | UID

I want to insert a product and then insert multiple prices into a seperate table. How is it possible to ensure that both tables had the same UID ideally an auto increment field? I will be using PHP alongside MySQL.

Thanks,

J

Upvotes: 0

Views: 1698

Answers (2)

desertwebdesigns
desertwebdesigns

Reputation: 1045

Make UID an auto_increment primary key on the products table, but just a regular primary key on the prices table (no auto_increment). After you insert itnto products, use the PHP command mysql_insert_id(). This will get the ID generated from the last query, which will be your UID generated on the products table. Assign it a variable and use it in your insert statement on the prices table.

http://php.net/manual/en/function.mysql-insert-id.php

Upvotes: 5

Will A
Will A

Reputation: 24988

Use a GUID for the UID, or better, insert your products and the insert the prices using e.g. the name of the product (assuming unique) to look up the relevant product UID.

Upvotes: 0

Related Questions