29.12.2017, 21:56
Your query only retrieves 1 result from the database.
If you want all of the results to be retrieved, remove the 'LIMIT 1' from the query. If you're testing it with this one business, I advise you to use 'printf' to print out values of the retrieved coordinates. Check if they match the records from your DB.
PHP код:
format(query, sizeof(query), "SELECT * FROM Businesses WHERE ID ='%d' LIMIT 1", BizzID);