[Resolved] Storing list in MySQL database

[dcjones]

HI all.

I posted a question like this and I thought I had the anwser, but no.

What I have is this.

I need to store data in my database which when shown on screen is in a bullet point list.

I have the code for the display:

 <? 
mysql_select_db($database_Chandos, $Chandos); 
$recordID = $_GET['recordID'];     

$query_DetailRS1 = mysql_query("SELECT * FROM chandos_books WHERE book_title = '$recordID'");  


$row = mysql_fetch_array($query_DetailRS1);  

$broken = explode(",", $row['key_features']);  

$countbroken = count($broken);  

echo "<uL>";  

FOR($i = 0; $i < $countbroken; $i++){  

  echo "<LI>".$broken[$i]."</LI>";  

}  

echo "</uL>"; 


?>

Example: I have a bullet list as shown below:

• Examines the wealth of electronic library resources
  Examines the development of e-learning/online learning
  Considers the role of the librarian in supporting e-learning / online learning
  Provides practical examples for librarians

Question. What format do I store the data in, and am I useing the correct code to display the results as a bullet list.

Please, I need help with this.

Kind regards, keep safe and well.

Dereck

[dcjones]

Hi and sorry for posting this POST

I now know I must end a string with a "," so that the script bullets the list.

Dereck