I am building an application that will request a record from a database, and put the results in an xml document for easy integration with google maps. The table fields will be as follows:
Business Name
Owner
Contact Person
Address1
Address2
City
State
Zip
Phone
Fax
Email
Website
Description Short
Description Long
Date Added
Date Suspended
How would I go about setting up an XML document to contain this information? Are there any tips to keep in mind while building the doc? Any advice would be appreciated.
Never used XML before - Need it for Google Maps App
Moderator: General Moderators
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
My first crack it this...
(structure only)
This is not meant to be actual XML code, but a quick crack at a possible structure of an XML document surrounding your data.
(structure only)
Code: Select all
<root>
<business>
<BusinessName>
<Owner>
<ContactPerson>
<Address1>
<Address2>
<City>
<State>
<Zip>
<Phone>
<Fax>
<Email>
<Website>
</business>
<description>
<DescriptionShort>
<DescriptionLong>
</description>
<dates>
<DateAdded>
<DateSuspended>
</dates>
</root>