Retrieving Data from a field within mysql + html not shown

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rgrund
Forum Newbie
Posts: 1
Joined: Sun Sep 14, 2003 4:26 pm
Contact:

Retrieving Data from a field within mysql + html not shown

Post by rgrund »

Hello,

I have a field in my mysql configured as longtext.

One entry has the following data:

<LI>Die <B>Generalversammlung</B> <B>2003</B> hat am 19. Februar 2003
stattgefunden.<BR><A class=fliesstextlink href="../club/aktuelles.html">mehr
unter Aktuelles & Information</A> </LI>

and the data will only be displayed as this

Die Generalversammlung 2003 hat am 19. Februar 2003 stattgefunden.mehr unter Aktuelles & Information

All the html codes which are stored in the databse are not shown.

Can some one tell me whyall the html codes are not shown? I need to show the html, otherwise the whole cms concept will not work.

Hope someone cane help me.

Best regards,
Bob
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Is the HTML stored as entities e.g. < not <? If so then it seems strange that it's not being displayed. Perhaps you should try using htmlspecialchars() on the data before you display it.

Mac
Post Reply