Finding closest number to given x and given y

[cody4camp]

I am designing a mmorpg guild site, and decided to make a coordinate database. A user will enter their own coords, x and y, and the 10 closest coords to them will be displayed.

 

I need help doing this. My table is:

 

id

coordx

coordy

alliance

region

 

I am using $_GET to retrieve the user's input. so

$_GET['mex']

$_GET['mey']

 

Thanks in advance for your help.