On Jan 29, 9:19 am, "[email protected]" <[email protected]> wrote: > Hi Larry, > > Sorry, I did have a bit of a trapse about, obviously completely missed > that. The URL ishttp://www.savant-health.com/pages.php?pageid=32 > > No idea on XML - runs off an SQL table called "markers", with the > columns: id, name, address, lat, lng, type, phone. Is it easier to do > this sort of thing with XML?
This is your xml: http://www.savant-health.com/phpsqlsearch_genxml.php?lat=51.5178525&lng=-0.1324175&radius=5 If you look at it you will notice that there are no phone or type attributes. You need to add them by modifying the phpsqlsearch_genxml.php program to get them out of the database and put them in the xml output. -- Larry > > Any uk town/postcode will pull up results, but so far I there is only > 1 phone number in the SQL table, for W1F 9US, but they all have a type > filled in, which comes up as null for every result. In fact, I'll just > put a load of junk numbers in the phone column now. > > Cheers, > > Tony > > On Jan 29, 4:37 pm, "[email protected]" <[email protected]> > wrote: > > > > > On Jan 29, 1:08 am, "[email protected]" <[email protected]> > > wrote:> Hi All, > > > > I've put together a store locator using the standard outlined example, > > > but would like it to pull information from 2 more column in my SQL > > > table. I'm not massively au fait with coding, so this has thrown me > > > completely, as outwardly I have zero idea why what I have done is not > > > working: > > > > ************************************************************************************************** > > > ... > > > > ************************************************************************************************** > > > > It's all reaonably standard, but should also call data from the > > > columns type and phone, the idea being that the type of store is then > > > displayed beneath the address, and the phone number beneath that. > > > However, it just returns "null" for both columns. I've copied the > > > settings for the name field in the SQL table for both type and phone, > > > and checked this worked by switching column names around, at which > > > point it did bring in the data from the columns it had previously > > > ignored. > > > > Is the script somehow coded to only be able to pull up data that it > > > was originally designed for?! Am I missing something terribly obvious? > > > There is a reason the posting guidelines ask for a link to your map > > that exhibits the > > problem:http://groups.google.com/group/Google-Maps-API/web/suggested-posting-... > > > What does your xml look like? > > > A link to your map and/or phpsqlsearch_genxml.php?lat=' + center.lat() > > + '&lng=' + center.lng() + '&radius=' + radius > > with some valid values might help... > > > -- Larry > > > > Put simply this has completely done my head in! > > > > Any help greatly appreciated > > > > Tony- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
