Hi. I got this remote xml that looks like the following sample. The number of videos are changing depending on xml that i use. I want to know how i can extract individual video information and set them as variable and write them to mysql. i be happy if some one show me how i can do this.Thanks


Code:
<?xml version="1.0" encoding="utf-8" ?> 
- <ut_response status="ok">
- <video_list>
  <total>33</total> 
- <video>
  <author>universalmusicgroup</author> 
  <id>6XENujsU3Wg</id> 
  <title>Shania Twain - You're Still The One: Blue Tint Version</title> 
  <length_seconds>208</length_seconds> 
  <rating_avg>4.88</rating_avg> 
  <rating_count>1741</rating_count> 
  <description>Music video by Shania Twain performing You're Still The One: Blue Tint Version with Shania Twain, R.J. Lange, Robert John "Mutt" Lange (C) 1998 Mercury Records, a Division of UMG Recordings, Inc.</description> 
  <view_count>615375</view_count> 
  <upload_time>1173705680</upload_time> 
  <comment_count>539</comment_count> 
  <tags>Shania Twain You're Still The One Country Mercury Nashville R.J. Lange Robert John "Mutt"</tags> 
  <url>http://www.youtube.com/?v=6XENujsU3Wg</url> 
  <thumbnail_url>http://img.youtube.com/vi/6XENujsU3Wg/default.jpg</thumbnail_url> 
  <embed_id>KD83gDBiCSFlUZz5yRJn5Eb0HRHg8u7iLK_1qXVk-dM=</embed_id> 
  <embed_status>not_allowed</embed_status> 
  </video>

.......
 </video_list>
  </ut_response>