I need to change prices based on manufacturer which is a custom propertie. Having looked in the access db it seems prices are in the products table and manufacturer is in the productproperties table.
Would it be possible to build a php page which updates the Actinic database via ODBC?
I understand how to build a query in php to get the info I need to update but I haven't a clue how to do this in access2000
My boss is barking at me that he needs to update 100's of product prices as the manufacturers have raised their prices and he doesn't want to sit down for days on end manually changing prices!
Any help would be greatly appreciated.
Thanks
Would it be possible to build a php page which updates the Actinic database via ODBC?
I understand how to build a query in php to get the info I need to update but I haven't a clue how to do this in access2000
My boss is barking at me that he needs to update 100's of product prices as the manufacturers have raised their prices and he doesn't want to sit down for days on end manually changing prices!
Any help would be greatly appreciated.
Thanks
Comment