Using the 'Less Than' symbol in query problem

[mat3000000]

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??

[livethedead]

I believe if you replace AND(s) with commas it should work.

[Pikachu2000]

What is the error?

[PFMaBiSmAd]

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

[mat3000000]

Thank You, I am now using 'HAVING' and it seems to work fine.