golffinder Posted April 16, 2009 Share Posted April 16, 2009 What i have is a "spot the ball" i have managed to get it to almost work in that, i can click the picture, collect the X & Y and then store them in db with, ID, name, email, X, Y what I'm after is, after people have had a go at this, how can i find the person nearest the ball, The way i see it working is, have some one see the app with the ball visable, they click the pictures as a "judge" to get the "winning" X & Y but then how do i query the db to find the person nearest to the "winning" X&Y from their choice? This the bit I have no clue on can see what i have so far here: http://www.golf-finder.net/test/spottheball/spot3000.php what i have stored in the db in table "userdetails" is id username email x y All very simple, but hopefully this is all i need? any help would be great Quote Link to comment Share on other sites More sharing options...
mandred Posted April 16, 2009 Share Posted April 16, 2009 Compare the x and y of the user to the ball's coordinates and whoever has the smallest distance can be considered closest. Quote Link to comment Share on other sites More sharing options...
golffinder Posted April 16, 2009 Author Share Posted April 16, 2009 Hi Yes sure, thats what i thought, but i don't have a clue how to write the query to do that, any ideas? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.