how to update quantity....??

[Joey]

hello people,

I use phpMyAdmin to administrate MySQL database v.4. i wana write a query to update my product's quantity with a file the manufacture gave me.

I have a table call products with the following fields:
- products ID
- products name
- products description
- products manufacture number
- products quantity
- products price
- products weight
- products image

My manufacture sent me a file in excel with the following fields:
- products number
- products description
- products quantity
- products price
- products weight
- products image

i wish to update my products table to reflect the new quantity counts from the manufacture excel file. plz help me in writing a statement that will compare products manufacture number from my table products with products number from the excel file AND UPDATE quantity field wit -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --