Help Completing GPS MySQL StoreProcedure Select Statement(repost)

I need a MYSQL stored Procedure to take in 3 params: CREATE PROCEDURE `distance`(IN mymsgid int,IN user_id int, IN mydistance float) BEGIN declare mylon double; declare mylat double; SELECT latitude, longitude into mylat, mylon from USER WHERE id = user_id; SELECT id, ( 6371 * acos( cos( radians(mylat) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(mylon) ) + sin( radians(mylat) ) * sin( radians( latitude ) ) ) ) AS distance FROM USER HAVING distance < mydistance ORDER BY distance LIMIT 0 , 20; END The code above returns ID and distance, but I need data from two tables joined by userid and msgid > mymsgid I have two tables I need joined that has a distance of myDistance. I will forward all the schemas once bidder is selected. Additional, if you have any GPS coordinate mysql experenice for faster queryies, if this is the best way to go. I do not plan on doing full table scans. I will send over the schemas