Splitting up a one field and out putting in separate table rows

[Smarky]

Righty, I have a field in a mysql database that contains some links, I need these links to be formatted in html on a separate row in a table although they are contained in the db as one.

output something like this

<tr> link one </tr>
<tr> link two </tr> etc..

It is stored in the DB in plain HTML with a <BR> tag between the links.

For example

<a href="link1"> link one </a> <br> <a href="link2"> Link two </a>.

So the <br> tags need to be striped, I guess this is what could be used to strip the data one by one, just need to know how to do this. Thanks

[The Mog]

here you go,

just use explode

<?php
// Below is your query
$links = "<a href=\"link1\"> link one </a> <br> <a href=\"link2\"> Link two </a>";
// Split them
$links=explode("<br>",$links);
// Print out the table
print "<table width=\"20%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
for($i=0;$i<count($links);$i++){
      print "<tr><td>".$links[$i]."</td></tr>";
      }
 print  "</table>";

?>