Hi there everyone,


I am using the following to grab the data I need from several tables:


$sql = "SELECT * FROM vendorprices LEFT JOIN fooditems on
(vendorprices.FoodItemNumber = fooditems.FoodItemID) WHERE
vendorprices.VendorNumber='$VendorID' ORDER BY


This works great, very fast etc .. the problem is, I then need to give the
option for them to edit the items - again, not a problem in populating the
form - until I have to then use the UPDATE function, how can I update each
item in separate tables when I use the above join to grab the info in the
first place?  I've never had to write to 2 tables at once where data is
relative like this, infact it was my first time of using JOINS at all to
even display the data.


I'm using PHP with MySQL.


Thank you.



Reply via email to