you know i did this last week and can't remember the functions is used.
i had exactly the same problem but had to dump the records as plain text
files.
i used get_html_translation_table . if you look at the example in the
compiled html help file for php there is a section of code that uses this
function and then array_flip to get the converted chars back into their
original symbols.
Steve
"John Pickett" <[EMAIL PROTECTED]> wrote in message
001f01c11064$d3fc8400$4c6146a6@notebook">news:001f01c11064$d3fc8400$4c6146a6@notebook...
> Howdy ;-)
>
> I have a problem when trying to display data in HTML from a MySQL query.
> Here's what happens:
>
> 1) I convert the text entered using htmlentities (). I then insert it
into
> the database table. If I do a query from a terminal on the data it looks
> fine.
>
> 2) When I do a select query on the data and then echo () it into a HTML
> page, all of the ' characters are preceded by an escape character \. I
> don't want this to happen...
>
> A few questions... First, would replacing the ' and " characters with
their
> HTML equiv pose problems when using them in say an img tag? I mean, does
> HTML expect the actual ' and " characters instead of " or whatever it
> is? If it doesn't matter, I can just convert everything to HTML.
>
> My other question requires explanation of what I'm doing... I'm trying to
> make it so my client can add their own news updates. Really simple stuff.
> However, sometimes I'll want to add news items for them that include some
> HTML (like an email link or whatever). However, the < and > characters
are
> being converted to < and > Will this actually work? Or do I need
the
> < and >? If so, how can I convert everything BUT actual HTML tags...?
I'm
> not far enough along yet where I can test this stuff myself, sorry :-/
>
> Thanx!
>
> My 2 ¢
> John Pickett
> http://www.bvstudios.com/
> Co-Author: Inside Dreamweaver 4
> http://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
