Jump to content

Adding a <br/> after loop section has ran


isimpledesign
 Share

Recommended Posts

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

Link to comment
Share on other sites

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 />";
}
?>

Link to comment
Share on other sites

This thread is more than a year old. Are you sure you have something important to add to it?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.