225675 Oscommerce - mysql/php

Need someone to do the following:

Read these values from a file:

products_model, products_price

Example (we can remove the dollars sign)

1234, $1.00

3333, $2.00

8888, $3.00

9191, $4.95

The above values will be in a text file or a excel (whatever you choose).

Then we need an sql statement that reads the above values from the file. Examples:

update products set products_price="1.00" where products_model="1234";

Why do we need done this way: Becasue we need to update our prices on regular bases and this is the best way we can think of.

We need this done fairly quick.

Thanks

MySQL Odd Jobs

Project ID: #1971912

About the project