Code: Select all
NAME||POINTS
==========
Matt ||45
==========
Dave ||13
==========
Matt || 23
==========
Steve|| 14
==========
etcThe bit I'm having some trouble working out how to do is how to pull out the results and work out the lowest three values. I was wondering if I could use the min(arg1,arg2,arg3...) function to do this with a loop that repeats three times so that every time I go through the loop I would extract the lowest value but how do I get the data out of the database and into the arg1, arg2 etc values? Is there some sort of array command or something I could use?
Any help that anyone can offer would be great!