Find Jobs
Hire Freelancers

A software to detect changes within to different rows in a table, mysql php

$30-250 USD

In Progress
Posted about 11 years ago

$30-250 USD

Paid on delivery
We need a small php script which connects to a mysql database and checks for differences between two rows. Assume we have a table as follows: primary_id, column A, column B 1 10 20 2 15 21 3 15 21 The php function take two inputs: id's to be checked for. If the inputs are to check for differences between id 1 and 2. Then the code will compare row 1 and 2. Assuming we have a change threshold of %10 percent previously set. Then the function will echo that there is a 50% change between row 1 and 2 on column A. It will echo the values 10 and 15 as well. However it will not say anything about column B, because the difference is only 5%. An important feature has to be that we should not define the columns. The php script should pull all column names by itself and do the comparison on all of them. So if there are 40 columns in a table, it should check all 39 columns except the primary_id column.
Project ID: 4371638

About the project

8 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Let me help you write the script to compare two rows of the table
$40 USD in 2 days
5.0 (22 reviews)
4.1
4.1
8 freelancers are bidding on average $42 USD for this job
User Avatar
Hi Haluk, I'm available to start right now and finish today. Best Regards. Leo.-
$55 USD in 0 day
5.0 (104 reviews)
6.6
6.6
User Avatar
Hi, Please check PMB, Thanks
$53 USD in 0 day
5.0 (18 reviews)
5.7
5.7
User Avatar
Hi, please check pmb
$163 USD in 1 day
4.7 (30 reviews)
5.4
5.4
User Avatar
I can get this done for you right away.
$45 USD in 0 day
4.8 (63 reviews)
5.2
5.2
User Avatar
Lets start the work. Thanks.
$35 USD in 2 days
5.0 (7 reviews)
3.4
3.4
User Avatar
Hi, We have done change based php sql programs before. Thanks
$30 USD in 1 day
5.0 (7 reviews)
3.2
3.2
User Avatar
I can provide you this script in 2 3 hours.
$35 USD in 0 day
5.0 (2 reviews)
1.5
1.5
User Avatar
This sounds quite straightforward, have sent you a PM with some further details.
$40 USD in 2 days
5.0 (4 reviews)
1.0
1.0
User Avatar
I have experience in php and database work. I can assure you quality of work.
$110 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of TURKEY
Istanbul, Turkey
5.0
14
Member since Aug 29, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.