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 Link to comment https://forums.phpfreaks.com/topic/154326-some-query-to-find-nearest-record/ 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. Link to comment https://forums.phpfreaks.com/topic/154326-some-query-to-find-nearest-record/#findComment-811369 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? Link to comment https://forums.phpfreaks.com/topic/154326-some-query-to-find-nearest-record/#findComment-811373 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.