## Featured Replies in this Discussion

- by pritaeas

0

For a moment I thought I was being REALLY stupid :D

Goedendag Pritaeious, but that only returns 1000 results even if there are 25000 matches. I want to make an initial query that will tell me the exact amount of matches and no data, and then a second query collecting the data with a limit of 1000, or one that does both if it is possible.

Thanks for your speedy consideration :D

1

Ah, okay. Just use the original query and select only `COUNT(*) AS resultcount`

. That way the server does the counting, but only one record gets transferred to your script.

```
select count(*) as resultcount
from SW
where (acos(cos(51.496502411798 * (PI()/180)) *cos(-0.13982862499836 * (PI()/180)) *cos(lat * (PI()/180)) *cos(lng * (PI()/180))+cos(51.496502411798 * (PI()/180)) *sin(-0.13982862499836 * (PI()/180)) *cos(lat * (PI()/180)) *sin(lng * (PI()/180))+sin(51.496502411798 * (PI()/180)) *sin(lat * (PI()/180))) * 3959) < 1
```

Question Answered as of 2 Years Ago by pritaeas

Isn't it about time forums rewarded their contributors?

Earn rewards points for helping others. Gain kudos. Cash out. Get better answers yourself.

It's as simple as contributing editorial or replying to discussions labeled OP Sponsor or OP Kudos

You

This question has already been solved: Start a new discussion instead