Insert HTML into MYSQL table

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
User avatar
Tyronem
Forum Newbie
Posts: 12
Joined: Thu Sep 14, 2006 5:11 pm

Insert HTML into MYSQL table

Post by Tyronem »

Hi all,

I am trying to insert HTML into a mysql table (news) (so my news items can look nice without having to type up multiple seperate pages)

table is fairly simple:

News_ID
News_Title
News_Teaser
News_Content - HTML gets inserted into this field

Standard insert (with no html) works fine

What data type in MySQL allows for HTML to be inserted into it?

Cheers.
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

User avatar
Tyronem
Forum Newbie
Posts: 12
Joined: Thu Sep 14, 2006 5:11 pm

.

Post by Tyronem »

Cheers,

also needed to convert to htmlspecialchars
(just found out)

Thanks!
ody
Forum Contributor
Posts: 147
Joined: Sat Mar 27, 2004 4:42 am
Location: ManchesterUK

Post by ody »

Post Reply