[Google Maps API v2] Re: URL variable to SQL query, creating XML

Beers for all you guys!

Thanks for the tip on viewing my XML file.

Andrew and Rossko you both were correct about passing through the JS
via "request.open..."

I managed to figure that out (I should get a book on JS):

// Read the data from example.xml
var request = GXmlHttp.create();
var Community_ID = window.location.search.substring(1); //THIS
IS NEW, gets the variable from the URL
var url = "special_inc/phpsqlajax_genxml_sites.php"; // THIS IS
NEW, creates the url variable to make things cleaner

request.open("GET", url+"?" + Community_ID, true); //LOL, this
is so easy. Passes the variable from the URL to the XML (PHP)

Strangely when I look at the XML now (special_inc/
phpsqlajax_genxml_sites.php) I get these errors:

Notice: Undefined index: Community_ID in /home/dsys/public_html/
testing/special_inc/phpsqlajax_genxml_sites.php on line 16
Invalid query: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near '' at line 1

But everything seems to work just fine on the output side. So, I am
sort of happy with it!

--
You received this message because you are subscribed to the Google Groups "Google Maps API V2" group.
To post to this group, send email to google-maps-api@googlegroups.com.
To unsubscribe from this group, send email to google-maps-api+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-maps-api?hl=en.