Mysql To Xml

[clank]

Is there a way to create an XML document based on values of a column in a mysql table?

eg if the total of students registered for a course(held in a student field) reaches 30, an XML document is produced and possibly sent somewhere??

Any IDEAS people?
Thank you.

[mooseday]

Do you want this to be automatic ( ie checked each time the database is updated with or without user intervention) or as a report that is run manually?

[clank]

I think automatically. Either at the beginning of each week something triggers it or a fied troggers after update.
Either will do, thanks