Menu
I have 2 tables:
1—product
2—product_category
On the product master entry php page I have a combo box to select a product category from it.
There is a common field name in both table “cat_id”
I want that when a user select the category from the combo box and submit the form a numeric value should be saved in the product table as “cat_id” which can be used to track the records on the basis of “cat_id” not category name
I thought to use the select statement in php but then what if I add some more category to the product_category table.?
I hope u all got me…
Please give me a solution….
Thanks in advance
Regards