Hello everyone,
I need help about this problem:
I have 3 tables in my bd, the first called stores(store_id,store_name), the second categories(category_id,category_name) and the third store_category(category_id,store_id).
And I have a form that allows me to add a new store to table store and its category or categories to table store_category.
What I am looking for is a way that allows me to get the id of the new store added so that I can put this id along with the category selected in table store_category.
is there any idea how to this with the same query? or any other idea that may help.
Thanks.
