hi all,
i have an application where you can create category and add products and save to Database.
i have order table and product table where you can create product (all product created goes here) and i also have link table order_product table.
now my problem is if i place a order which has for instance with 2 products i want only order and link table to be saved like,
order table ------ order_product------ product table
1 1 2 1
2 1 3 2
3 2 2 3
so when i submit order I'll have product id's i.e 2,3,2 using these product ID i need to update link table and order table.
is there a way to do this? please help
i have an application where you can create category and add products and save to Database.
i have order table and product table where you can create product (all product created goes here) and i also have link table order_product table.
now my problem is if i place a order which has for instance with 2 products i want only order and link table to be saved like,
order table ------ order_product------ product table
1 1 2 1
2 1 3 2
3 2 2 3
so when i submit order I'll have product id's i.e 2,3,2 using these product ID i need to update link table and order table.
is there a way to do this? please help