insert html code into table

[renny]

Hello,

I would like to store a line or two of HTML code into the database and retrieve it when I need it.

What type of field should I use for the column and how should I store it using PHP? I was thinking about something along the line of addslashes but I am not sure.

Your help is much appreciated.

Thanks
-R

[marijn]

Hi,

What I would do is store normal linknames & linkurls into the database like:

name..................... link
Marijn's page......... www.marijn.com

And then retreive it in like this:

<a href="http://<? echo($link); ?>"><? echo($name); ?></a>

For the fieldtype I normally use the standard 'varchar', which works fine.

[dniry]

or if you really need to customize content based on different scenarios and want the html in a table, use a text field.

table html (
html_id int(11),
html_content text
)

indeed, you will definitely want to use addslashes on the html inputbefore you insert it in mysql