Content of db cell on new lines

[Anon]

Hi, I've got a small problem with the content of one of the cells in my database. I need a question, stored in my database as a single cell, to be echoed on a number of lines, i.e. a new line for each bullet point in the question.

I have tried putting in breaks (<br>), but it doesn't work, it simply echoes the <br> tag in the question.

Does anyone know how I can get around this?

Thanks, Sarah

[ayzee01]

sorry but your explanation is a little vague.

i'm assuming you have a question with several bullet points in your db, and you want to seperate the bullet points when you echo out the data??? If this is correct then try this:

when inputting your question to the database, where you want the bullet point to begin and end, do something like the following:

question 1: have i got this right?$@1#@2#@3#%

let me explain my thinking:

$ = start of list
@ = beginning of bullet point

= end of bullet point

% = end of list

then when taking the data from the database do something like:

$str_Question = your database data

$str_Question = str_replace ("$", "<ul>", $str_Question);

$str_Question = str_replace ("@", "<li>", $str_Question);

$str_Question = str_replace ("%", "</li>", $str_Question);

$str_Question = str_replace ("$", "</ul>", $str_Question);

echo $str_Question;

and you should hopefully have a correctly formatted list in HTML.

hope i've been of help.

cheers.