numerical table sort

IN PROGRESS
Bids
18
Avg Bid (GBP)
£78
Project Budget (GBP)
£20 - £250

Project Description:
I have a mySQL database table which has 5 fields, the first 4 of which would have at least 1 number in the format decimal(10,4) The fifth field is a varchar field with descriptive text.
I require some sort of search and display facility (in php) that will display two fields with the numbers in ascending form from any of the 4 numerical fields, and the associated descriptor field.
The attached tables perhaps best shows what is required.
Of course this is a simplification and the actual table has over 100 fields and about 800 records, but the mechanism required manipulates the 5 fields mentioned.

Skills required:
MySQL, PHP, Software Testing
Additional Files: input-example.png requirement-output.png
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 52
in 1 days
Hire DrTech76
£ 25
in 0 days
Hire shihan033010
£ 55
in 1 days
£ 32
in 3 days
Hire finecodervw
£ 150
in 6 days
£ 154
in 2 days
£ 32
in 0 days
£ 78
in 1 days
£ 20
in 0 days
£ 20
in 0 days