Bluehost.com Web Hosting $6.95

newbie: resultset as xml, HOW?

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 ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 01-30-2007
Jeff
 
Posts: n/a
Default newbie: resultset as xml, HOW?

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



Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 03:03 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0