Adding a <br/> after loop section has ran

[isimpledesign]

hi i have got the following issues i am using the following code.

 

<?php

//DB CONNECTION

$ROWS = "id,firstname,lastname";

// explode at the comma and insert into an array
$test = explode("," , $ROWS);

//adds array test to the var sam
$sam = array($test);

// querys the database
$new = mysql_query("SELECT * FROM {$DB_TABLE}");

// while loop to loop through selected fields
while ($row = mysql_fetch_array($new)) {

foreach ($sam[0] as $v) {

	echo $row[$v] . $DELIMITER . "<br />";

}

}
?>

 

i get the following results.

 

834(|)

Steph(|)

Thompson(|)

835(|)

Lucy(|)

kim(|)

836(|)

Iwan(|)

Will(|)

837(|)

Sarah (|)

Good(|)

 

The problem i have is the br tag where do i put it because i need it to output like this. like it shows in the $ROWS variable above "$ROWS = "id,firstname,lastname";";

 

 

834(|)Step(|)Thompson(|)

835(|)Lucy(|)kim(|)

836(|)Iwan(|)Will(|)

837(|)Sarah (|)Good(|)

 

Where do i add the br tag???

 

Any Help PLease

[litebearer]

Perhaps...

<?php
//DB CONNECTION
/* Unless your are at some point changing what fields to gather  the following is un-necessary 

$ROWS = "id,firstname,lastname";
$test = explode("," , $ROWS);
$sam = array($test);
*/

$new = mysql_query("SELECT * FROM {$DB_TABLE}");
// while loop to loop through selected fields
while ($row = mysql_fetch_array($new)) {
echo  $row['id'] . $DELIMITER . $row['firstname'] . $DELIMITER . $row['lastname'] . $DELIMITER . "<br />";
}
?>