Create XML playlist from mysql DB for Flash FLV player in C#

[PX77]

Im trying to create a page for a university project that dynamically displays a list of videos in a flash player from data stored in a Mysql database. i already have the player running correctly from a simple XML list but I need to get the right data from the database and convert it to an XML list to display the playlist according to the currently selected video. The XML list looks like this:\[code\] <?xml version="1.0" encoding="utf-8"?> <item> <list name="A really awesome video of Declan's face." videotitle="Declan Video" link="0001.flv" > <thumb>thumb/1.jpg</thumb> </list> <list name="Test content - Video of Wenlong and Jing" videotitle="Final matrix demo 2" link="test1.flv" > <thumb>thumb/2.jpg</thumb> </list> <list name="Video of Wenlong and Jing" videotitle="Matrix film demo 1" link="test2.flv" > <thumb>thumb/1.jpg</thumb> </list> <list name="Video of Wenlong and Jing" videotitle="Final matrix demo 2" link="test4.flv" > <thumb>thumb/2.jpg</thumb> </list> <list name="Video of Wenlong and Jing" videotitle="Matrix film demo 1" link="wenlong1.flv" > <thumb>thumb/1.jpg</thumb> </list> </list> </item>\[/code\]Any ideas on how to best achieve this? Help would be greatly appreciated.Thanks!