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, $[url removed, login to view]

3333, $[url removed, login to view]

8888, $[url removed, login to view]

9191, $[url removed, login to view]

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="[url removed, login to view]" 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: 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, php sql update, mysql php example, oscommerce sql update, whatever think best, mysql quick, php mysql statement, mysql statement, php update excel file, sql php oscommerce, 1234, php mysql update excel, values statement

Tentang Majikan:
( 51 ulasan ) Alpharetta, United States

ID Projek: #1971912

Dianugerahkan kepada:

bihpsl

Details in PM.

$15 USD dalam 0 hari
(53 Ulasan)
4.9