You have chosen to sponsor your bid up to a maximum amount of .
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.