php mysql updating in multiple tables

Question

I have 3 tables:

Products containing IDProduct, IDCategory, Name
Suppliers containing IDSupplier, SupplierName, Phone
ProductSupplier containing IDProduct, IDSupplier, Price, Quantity

I want to update (edit) the following: IDCategory, Name(product), IDSupplier, Price, Quantity, but i'm not doing the UPDATE query right:

$query="UPDATE products P, 
               category C, 
               suppliers S, 
               productsupplier PS 
           SET P.IDCategory = '$idcategory', 
               P.Name = '$Name', 
               S.IDSupplier = '$idsupplier',  
               PS.Price = '$Price', 
               PS.Quantity = '$Quantity'
         WHERE ((IDProduct = '$idproduct') 
           AND (P.IDProdus = PF.IDProdus) 
           AND (PS.IDSupplier = S.IDSupplier ) 
           AND (P.IDCategory = C.IDCategory))");

How do i do this right? Thank you!

PF.IDProdus shouldn't it be PS.IDProdus? there is no PF table — The Scrum Meister
– The Scrum Meister, Commented Jan 13, 2011 at 19:42

Geoffrey Wagner · Accepted Answer · 2011-01-13 19:26:22Z

1

http://forums.mysql.com/read.php?20,85813,85813#msg-85813 this thread should give you all the answers you need. In essence you should be using a join.

answered Jan 13, 2011 at 19:26

Geoffrey Wagner

8181 gold badge5 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

php mysql updating in multiple tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related