can anyone tell me what's wrong?
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;
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.