Re: Slightly OT: MySQL + PHP and escaping data to output to a web page

2004-04-15 Thread Daniel Kasak
Mark Susol | Ultimate Creative Media wrote: On 4/15/04 11:49 PM, "Daniel Kasak" <[EMAIL PROTECTED]> wrote: I'm currently using: replace(replace(NoteText, '<', '<'), '>', '>') as NoteText to replace the offending characters with HTML escape codes. Is there a cleaner way of doing this? Yo

Re: Slightly OT: MySQL + PHP and escaping data to output to a web page

2004-04-15 Thread Mark Susol | Ultimate Creative Media
On 4/15/04 11:49 PM, "Daniel Kasak" <[EMAIL PROTECTED]> wrote: > I'm currently using: > > replace(replace(NoteText, '<', '<'), '>', '>') as NoteText > > to replace the offending characters with HTML escape codes. Is there a > cleaner way of doing this? You can try the php command: htmlspecialc

Slightly OT: MySQL + PHP and escaping data to output to a web page

2004-04-15 Thread Daniel Kasak
Hi all. Yes I know this is a little off-topic, but also a little on-topic... I have a user who likes to use the 'less than' sign ( < ) in notes he enters into the DB. When I print them out to a web page, they are interpreted as an HTML code and everything after them '<' is not printed. I'm curr