Sedang Disiapkan

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

Kemahiran: Semua Boleh, MySQL

Lihat lebih lanjut: update oscommerce 2.2 to 2.3.1, sql update text, php remove text, excel file mysql, php file remove, php read text file, php mysql sql example, php remove file, remove text php, update text sql, php excel read, mysql update values, update values mysql, excel update mysql, sql update text text, php sql update, mysql php example, oscommerce sql update, whatever think will best, mysql quick, php mysql statement, mysql statement, php update excel file, sql php oscommerce, 1234

Tentang Majikan:
( 53 ulasan ) Alpharetta, United States

ID Projek: #1971912

Dianugerahkan kepada:

bihpsl

Details in PM.

$15 USD dalam 0 hari
(53 Ulasan)
4.9