CODEWITHSUNDEEP
phpmysql
Genadinik
Genadinik

Reputation: 18639

How to scroll through a count query in MySQL/PHP

I have this query:

select count(*) , ( 3959 * acos( cos( radians( 34.469994 ) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians( -118.196739 ) ) + sin( radians( 34.469994 ) ) * sin( radians( lat ) ) ) ) AS distance from users HAVING distance < 150

Which is supposed to get users within 150 miles of a certain latitude and longitude.
How can I get the number of the count(*) part?

Also, any idea how to toggle such a query between miles and kilometers?

Thanks!

Upvotes: 0

Views: 183

Answers (1)

Steve Nguyen
Steve Nguyen

Reputation: 5974

select count(*) as count, ( 3959 * acos( cos( radians( 34.469994 ) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians( -118.196739 ) ) + sin( radians( 34.469994 ) ) * sin( radians( lat ) ) ) ) AS distance from users HAVING distance < 150

Upvotes: 3

Related Questions