Ok, feel stupid now... Completely forgot about that php - had originally put this together before xmas, and was just looking into it again.
Thanks a bundle for pointing out what I was missing, all sorted now :) Cheers, Tony On Jan 29, 6:26 pm, "[email protected]" <[email protected]> wrote: > 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&l... > > 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 -~----------~----~----~----~------~----~------~--~---
