I am starting to learn PHP;
i have two tables in my database:
- the Brands List that contains Brand_ID, Brand_Name, and Brand_Description.
- the Product Lines List that contains Line_ID, Line_Name.
i want to create a third table named Offered Products that contains Offer_Id, Brand_ID, Line_Name - how can i manage this using Foreign Keys?
After creating the table, i want to create a php page that will let users to populate the third table by
- Selecting a brand from a dropdown list
- Selecting a Line Name from a drop down List
- Beside it has a button "Add Row" - which when click will display another row below the first one in order to do number 1 and 2 again and so on
- A save button is also present which when clicked will finally save the record on my database.
how can i exactlydo this? please help