adding into multiple tables

[sturgeon]

Hello All,

 

I am creating a shopping site, I have two tables orders and order_items. I am keeping order date and user id in orders table.

In order_items i  am keeping order_id, product_id and quantity. The problem i am facing is, when the user puchases products how will i add datas to these tables both. I mean i add order date and user id in orders table but i should add them to order_item table but how will i add the order_id in that table? If you understand and reply to me i am so glad.

 

Thank you very much and have a nice day.

[Mchl]

mysql_insert_id will give you last ID inserted with previous query.

[sturgeon]

Thank you, Ok but what will happen when another user purchases something and added to orders ? the id's will differentiate ?

[Mchl]

I'm not sure. I'd guess that it will keep the data for current connection (i.e. other users' action should have no effect).

However you can always lock both tables for writing before you do inserts (remember to unlock after), or use transactions (InnoDB storage required).

[sturgeon]

Thank you for your replies Mchl, I will try that.