houssam_ballout Posted June 16, 2011 Share Posted June 16, 2011 Hello ,I need help with this issue:I had a table called products and a table called vendorsI made a page to create a new vendor, I need to edit it to make the ability to add no of products associated to that vendor.Any help?Thanks in advance Link to comment Share on other sites More sharing options...
thescientist Posted June 16, 2011 Share Posted June 16, 2011 I would make a field in the products table called vendor, and make it a foreign key (to the vendors table). So you will have a list of products, with one of the fields being vendor, and that will allow you to show products associated with a vendor. Link to comment Share on other sites More sharing options...
houssam_ballout Posted June 16, 2011 Author Share Posted June 16, 2011 How can insert multiple selected products into mysql db & how can retrieve them for further editing.Thanks Link to comment Share on other sites More sharing options...
justsomeguy Posted June 16, 2011 Share Posted June 16, 2011 The same way you insert or update any other data. Which part are you having a problem with? Link to comment Share on other sites More sharing options...
thescientist Posted June 16, 2011 Share Posted June 16, 2011 you can either do it manually using phpMyAdmin or a client application like MySQL workbench, or you can make your own scripts do it for you. (i.e. a form for adding/updating the data yourself.) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.