I was wondering if sombody can help me ad more parameters to my search. i have added additional tables to my database. i want to be able to search a location within a radius for repair agents that fix Sony Lcd TV's for example.
The map can be found http://www.globalconnections.com.au/ type mountain view, ca into the address. At the momment im trying to pass the manufacture and category variables via the browser like this: function searchLocationsNear(center) { var radius = document.getElementById('radiusSelect').value; var manufacture = document.getElementById('menuInput').value; var category = document.getElementById('catInput').value; var searchUrl = 'phpsqlsearch_genxml.php?lat=' + center.lat() + '&lng=' + center.lng() + '&radius=' + radius + '&manufacture=' + manufacture + '&category=' + category; GDownloadUrl(searchUrl, function(data) { I have added this to the php page. $manufacture = $_GET["manufacture"]; $category = $_GET["category"]; now with the query, when ever i modify it, it will display no data. $query = sprintf("SELECT address, name, lat, lng, ( 3959 * acos( cos ( radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) ) AS distance FROM markers HAVING distance < '%s' ORDER BY distance LIMIT 0 , 20", mysql_real_escape_string($center_lat), mysql_real_escape_string($center_lng), mysql_real_escape_string($center_lat), mysql_real_escape_string($radius)); what do i need to add here? My sql query need to look somthing like: SELECT markers.name, manufactures.brand, category.product FROM markers, manufactures, category WHERE manufactures.markers_id = markers.id AND category.manu_id = manufactures.id AND manufactures.brand = "LG" AND category.product = "Washing Machine"; Where LG and Washing machine are the variables are those that were passed on..($manufature. ect) and the google map lng lat query passed as well. Any help would be great. Regards, Justin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Maps-API?hl=en -~----------~----~----~----~------~----~------~--~---
