check for open tags on input for XML?

[orionblue]

Hello,

After trying to sort out my 'cross server database access' problem, I have decided to go with XML as a display (not update) method.

Problem is, if users don't close their tags properly (they can modify their entries using an HTML WYSIWYG to format paragraphs, font style, etc.) the output is broken as XML won't handle an improperly syntaxed tag coming from the mysql db:

• ie. <note><p>these are my notes</notes> will stop the output.

My question - how to allow for use of HTML input but to prevent the 'bad tag' problem?

thanks...