Using latitude/longitude extend search?

PHP
1

Hello,

I like to create or extend a search based on latitude/longitude from current location.

Using kijiji as an example, a user searchs for a item within his/her city/town and finds
nothing. If nothing is found in the immediate location how do I extend the search to include the next or the nearest
towns & cities based on current location.

I have access to latitude & longitude.

PHP scripting.

2

You could use PDO’s rowCount() but it is a bit flaky sometimes. You could also execute a separate query with SELECT COUNT(*) to see how many results are returned.

3

There have been several threads in this forum about how to derive distance from lat/long pairs…