A Flash Developer Resource Site

Results 1 to 1 of 1

Thread: Breaking down some XML to save in database...

  1. #1
    Senior Member
    Join Date
    Feb 2003
    Posts
    272

    Breaking down some XML to save in database...

    Hello there!

    I am working on creating a game in which the user must identify different parts of a sentence. To make it a bit more expandable, I am trying to save the XML that powers the game into a MySQL database. Ideally, I would be able to save each sentence into its own row, and still have the attributes regarding each chunk of it split up separately. Take a look at some example XML:

    HTML Code:
    <sentences>
    	<sentence id="1">
    		<chunk part="na">In the morning</chunk>
    		<chunk part="sub">the children</chunk>
    		<chunk part="trans_verb">eat</chunk>
    		<chunk part="d_o">their cereal.</chunk>
    	</sentence>
    </sentences>
    As you can see, the sentence is broken into chunks, and each chunk has a 'part' attribute. Please help me figure out the most efficient way to save this into a MySQL database (keeping in mind that it will be entered into the database by a user with an HTML form, and should be editable later by the same user... I will handle all the details, but just keep your responses in that context).

    Thanks!
    -Ange52
    Last edited by Ange52; 10-01-2005 at 05:00 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  




Click Here to Expand Forum to Full Width

HTML5 Development Center