MySQL Forums
Forum List  »  Newbie

can anyone tell me what's wrong?
Posted by: algren cole
Date: June 07, 2005 03:19PM

so this is a distance search function i've been working on....it worke with MySQL4.0 but when we upgraded to 4.1 it suddenly stopped working anyone have any ideas?

SELECT *, (0 * SIN(latitude * 0.0174532925199) + 1 * COS(latitude * 0.0174532925199) * COS((longitude * 0.0174532925199) - 0)) AS dist
FROM user_search
HAVING (3963 * (-1 * ATAN(dist / SQRT(1 - dist * dist)) + 1.57079632679)) < 99999
ORDER BY dist DESC
LIMIT 0, 48;

Options: ReplyQuote


Subject
Written By
Posted
can anyone tell me what's wrong?
June 07, 2005 03:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.