ordering by proximity

[yahelb]

Hi,
I've encountered a problem, i need to organize a result set by thier proximity to a given number, for example:
I have a list of numbers:
10
5
30
20
60
50

I want a query that can return them in the following order if i give it the number 50:
54
50
60
30
20
10
5

Thank you.

[barand]

Try

$mynum = $GET["mynum"];
$sql = "SELECT num, Abs([num]-$mynum) AS seq
FROM Table1
ORDER BY Abs([num]-$mynum)";

hth