I gang

Data transfer/update with php script

Please don't bid on this project as it is already assigned for someone.

I have four tables: old_products, old_products_description, new_products, new_products_description. I need a script that will transfer data between the two tables. Here are the specifications:

old_products has the fields: old_products_id (int), old_products_model (varchar)

old_products_description has the fields: old_products_id (int), old_products_description_name (varchar), old_products_description_langauge_id (int)

new_products has the fields: new_products_id (int), new_products_model (varchar)

new_products_description has the fields: new_products_id (int), new_products_description_name (varchar), new_products_description_langauge (int)

My aim is to copy (update) the field new_products_description_name with the data from old_products_description_name where new_products_model = old_products_model and new_products_description_langauge_id = 5. Also note that the four tables are pairs (connected to each other) through their id field. So a product with old_products_id = 45 in old_products table, will always have old_products_id = 45 also in old_products_description. Same goes for the new_products/new_products_description tables. But there can be several rows with id = 45 in old_products_description/new_products_description for each product because a product can have names in different languages (with different language id's). But ID 45 can only have one entity of old/new_products_description_langauge_id =5. In old_products/new_products the ID is unique.

So I need a simple php script to handle this. The database is mysql and it only need to run when running it by viewing it in a browser.

Færdigheder: PHP

Se mere: transfering data php scripts, update data transfer, php script data update, script update post data, data transfer php, phpscript update, php data update script, php scripts update data, count php transfer data, script data transfer, transfer data php scripts, update data php script, script php transfer money, php post data transfer, script update data, please different languages, my transfer, update project, update old, update mysql, transfer product data, run update, php language project, int, data transfer

Om arbejdsgiveren:
( 33 bedømmelser ) Drammen, Norway

Projekt-ID: #289038

Tildelt til:

SudarMuthu

As discussed. Thanks!

$50 USD in 2 dage
(30 bedømmelser)
5.3

3 freelancere byder i gennemsnit $75 for dette job

stumpyb

I can do this for you, thanks for your consideration.

$100 USD på 1 dag
(0 bedømmelser)
0.0
alphawiz

please disregard, I missed the 'do not bid' entry

$75 USD på 1 dag
(0 bedømmelser)
0.0