mat3000000 Posted February 18, 2012 Share Posted February 18, 2012 I have a query to search jobs. It also works out the distance from the user to the job: SELECT ((ACOS(SIN('$b_lat' * PI() / 180) * SIN(`lat` * PI() / 180) + COS('$b_lat' * PI() / 180) * COS(`lat` * PI() / 180) * COS(('$b_long' - `long`) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS `distance`,username,sector,job,pay,reqexp, jobtime, hours, hourscat,days,description FROM `jobs` WHERE sector='$sector' AND job='$job' AND validated='1' AND `distance` < 80 ORDER BY `distance` DESC; I am getting an error when running this, however, when I remove the "AND `distance` < 80" clause it works fine. Whats the problem here?? Link to comment https://forums.phpfreaks.com/topic/257269-using-the-less-than-symbol-in-query-problem/ Share on other sites More sharing options...
livethedead Posted February 18, 2012 Share Posted February 18, 2012 I believe if you replace AND(s) with commas it should work. Link to comment https://forums.phpfreaks.com/topic/257269-using-the-less-than-symbol-in-query-problem/#findComment-1318703 Share on other sites More sharing options...
Pikachu2000 Posted February 18, 2012 Share Posted February 18, 2012 What is the error? Link to comment https://forums.phpfreaks.com/topic/257269-using-the-less-than-symbol-in-query-problem/#findComment-1318710 Share on other sites More sharing options...
PFMaBiSmAd Posted February 18, 2012 Share Posted February 18, 2012 You cannot use values that are derived in the SELECT clause, in the WHERE clause, because they don't exist when the WHERE clause is used (to determine which rows are in the results set.) You would need to use HAVING `distance` < 80 Link to comment https://forums.phpfreaks.com/topic/257269-using-the-less-than-symbol-in-query-problem/#findComment-1318714 Share on other sites More sharing options...
mat3000000 Posted February 21, 2012 Author Share Posted February 21, 2012 Thank You, I am now using 'HAVING' and it seems to work fine. Link to comment https://forums.phpfreaks.com/topic/257269-using-the-less-than-symbol-in-query-problem/#findComment-1319660 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.