Mysql to xml

helo…

i’ve done loads of research work but i can not get what i wanted. Hope someone can help me here.

am actually developing a live chat using php, mysql and C#. One side of the chat will be a web application and the other side will be a window application(like live messenger). i want to use XML in order to use the data, i.e, date,chat body and username to communicate with the window application.

how can i get all the records from the mysql database, convert it to XML and then use the XML file for the window application(i.e, for C#)? And how can i add new entries in the XML file through mysql database automatically? This must be done in real time.

it’s urgent! :frowning:

i’ll be grateful if someone can give the source code and explain how to do it…

thank u in advance…