isimpledesign Posted March 10, 2011 Share Posted March 10, 2011 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 https://forums.phpfreaks.com/topic/230199-adding-a-after-loop-section-has-ran/ Share on other sites More sharing options...
litebearer Posted March 10, 2011 Share Posted March 10, 2011 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 https://forums.phpfreaks.com/topic/230199-adding-a-after-loop-section-has-ran/#findComment-1185516 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.