In Progress

Need PHP programmer to make script to update MySQL database

FIELDS: ID, Column1, Column2, etc.

1. I need a PHP script for my MySQL database that will update a field (Column1) in all rows found with a text that I will define.

2. The rows to appear in the results are rows that have duplicate content with other rows regarding a field (Column1)

3. The script will need to search all tables containing a specific text (for exemple, search all tables in a database containing the word "data" in the table's name)

4. Moreover, within the duplicated rows, all of them must be updated (as stated in point 1.) ...except the row with the oldest datetime date within the same table (between the rows with the same duplicate content)

5. The search must only take into consideration rows where Column1 have at least x number of character (for example... 3... in this example below)

6. I would like options in a config file to: set if i want to run in test mode (showing all results found without updating the data), set the number of character minimum to consider, set the table's name keyword to consider, set the number of rows NOT to be updated (see point 4.)

7. I would like another search option that does the following: update all the row's field (Column1) if a string that I provide is found exactly or within other rows' field (Column1)... including all tables with a specific keyword (like in point 3.) I would also like a test mode for point 7.

EXAMPLE: (for points 1 to 5)

table_house (column with the date related to table "table_house_data" below) ...the date table is a table without the "_data" suffix

ID | Date (datetime type)

1 | 2005-07-15 16:32:54

2 | 2005-04-20 16:32:54

3 | 2005-12-30 16:32:54

4 | 2005-08-08 16:32:54

table_car

ID | Date

1 | 2001-07-15 16:32:54

2 | 2005-04-20 16:32:54

3 | 2003-12-30 16:32:54

4 | 2007-08-08 16:32:54

table_monkey

ID | Date

1 | 2006-05-15 16:32:54

2 | 2000-03-20 16:32:54

table_house_data

ID | Column1

1 | hey you yada

2 | money

3 | plane

4 | money

table_car_data

ID | Column1

1 | money

2 | hi

3 | hi

4 | plane

table_monkey_someothertable

ID | Column1

1 | money

2 | plane

The script would output (to show the duplicates):

DUPLICATE | TABLENAME | ID | DATE

money | table_house_data | 2 | 2005-04-20 16:32:54

money | table_house_data | 4 | 2005-08-08 16:32:54

money | table_car_data | 1 | 2001-07-15 16:32:54

plane | table_house_data | 3 | 2005-12-30 16:32:54

plane | table_car_data | 4 | 2007-08-08 16:32:54

And it will only update

money | table_house_data | 2 | 2005-04-20 16:32:54

money | table_house_data | 4 | 2005-08-08 16:32:54

plane | table_car_data | 4 | 2007-08-08 16:32:54

...and replace "money", "plane" or any other string in the result by a text that a would decide.

Skills: Data Processing, PHP, Script Install

See more: text string, text string search, search text string, search php programmer, search character string, programmer mysql, need money programmer, make set, found programmer, be programmer, mysql searchalltables, update mysql field script, php shopping database plane, php update, scripts update tables database, updater php script, php update fields, php script updating mysql, update php script example, word script, update mysql, plane, need php, need database programmer, it programmer

About the Employer:
( 14 reviews ) Montreal, Canada

Project ID: #201092

Awarded to:

ErsanJSano

Hi, I can do this fast and for a fair price. Best regards, -Ersan

$30 USD in 1 day
(6 Reviews)
3.2

19 freelancers are bidding on average $80 for this job

e3d

Can be done

$99 USD in 2 days
(76 Reviews)
7.8
becomeexpert

Let's start :)

$100 USD in 5 days
(159 Reviews)
7.6
BirdWatcher

Hello! I can do it for You for only $95. It will take me no longer than 24-48 hours. If You choose me I will do my best to do it as soon as possible. thanks Birdwatcher

$95 USD in 0 days
(62 Reviews)
7.4
aamirpitafi

Hi, Please check pm. Thanks

$65 USD in 5 days
(39 Reviews)
6.4
bsoist

Please see PMB.

$100 USD in 2 days
(42 Reviews)
6.5
contentguru

Escrow required to start. Thanks.

$100 USD in 3 days
(29 Reviews)
6.3
kopila123

please view pm

$100 USD in 2 days
(110 Reviews)
6.3
milliard

Hello, We can do this project. Thank you

$50 USD in 2 days
(12 Reviews)
5.6
rasaintnet

Can be done.

$70 USD in 2 days
(18 Reviews)
5.5
dreamcorner

can be done sir.

$100 USD in 1 day
(28 Reviews)
4.9
alkweb

can do ASAP

$75 USD in 3 days
(2 Reviews)
2.2
etindore

Can be done in 1 day. 6 yrs of experience in PHP

$40 USD in 1 day
(1 Review)
1.0
Xtremelogique

Our organisation Xtreme Logique is the brainchild of talents blended with Experience and Expertise of multi-dimensioned personalities in various technologies. Xtreme Logique is being headed by a person who has more More

$50 USD in 7 days
(0 Reviews)
0.0
krissauquillo

I can do this for you. The description sounds simple enough and I can get a sample page up tomorrow after my finals. http://www.vilegaming.com is a sample of my quality work.

$75 USD in 3 days
(0 Reviews)
0.0
thiyagu12

Well and wish you the same. I am 4+ years experinced programmer in PHP, MYSQL and also having sound knowledge on Ajax, Smarty, Javascript, Ecommerce Technologies. I had listed few of my sample sites on various technolo More

$90 USD in 5 days
(0 Reviews)
0.0
j2ane

Good day sir, im a php/mysql programmer i would like to get this project. im very interested in this project hope to be considered Thanks

$100 USD in 3 days
(0 Reviews)
0.0
kafan

hi, we are future designers. we can complete the project within the time schedule. Waiting for your reply

$79 USD in 5 days
(0 Reviews)
0.0
studentfree98

hi, we are available now thank you

$100 USD in 2 days
(0 Reviews)
0.0