How to extract remote xml items and write them to mysql

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>

---