PHP / SQL / XMLReader - Update big table using another
0
Im using XMLReader to import product to my SQL table. There is 62419 items in 'products' table. Sometime in first .xml file there is no price for products but they are on second file. So im using again XMLReader to store this prices in 'products_prices' table. Right now i`v got 50912 item in this table. I need solution how update prices in 'products' table using 'products_prices'. Schema for 'products' table: id pxmlId pprice psale_price Schema for 'products_prices' table: id pxml_id pprice psale_price 'pxmlId' and 'pxml_id' are the same - and this is ID product from both .xml files. What I've tried: First fill 'products_prices' table then when XMLReader read .xml files for 'products' table i send query to ...