[Wolves] Scuba php calculator

[Wayne Morris]

Mike Peters wrote:

>If your table, times, looks like:
>+-------+-----+----+-----+
>| result   | d10 | d12 | d15 |
>+-------+-----+----+----+
>| A          | 10    |  9   |  8  |
>| B          | 19    | 16  | 13 |
>| C          | 25    | 22  | 17 |
>+-------+-----+----+----+
>
>then:
>SELECT result FROM `times` where d15 > 16 order by d15 limit 1;
>
>will give you the first result from column d15 above 16, ie:
>
>+-------+
>| result   |
>+-------+
>| C         |
>+-------+
>
>HTH
>  
>
Excellent, up and running thanks!