This is a discussion on newbie: resultset as xml, HOW? within the MySQL Database forums, part of the Database Forums category; Hey I'm using PHP 5.2.0 and MySql 5 to create a web site. Now I'm trying ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Hey
I'm using PHP 5.2.0 and MySql 5 to create a web site. Now I'm trying implement ajax (google map).. In the database I've got the longitude & lattitude of positions on the map... I want these positions sent (as xml) from the database so they can be displayed as markers on the map.... so my questions is: How can I convert the select below so that the resultset is xml? select longitude, lattitude from location where id = 1; (I ask because I've got some experience with MS Sql Server, which have the XML option to the select.... in MS Sql Server I think this could have solved it (maybe syntax is wrong): select longitude, lattitude from location where id = 1 for XML.... but I don't know if this can be done in mysql...; ) Any suggestions? Jeff |