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 />"; } echo "<br />"; } ?> This will output the following . 834(|)Step(|)Thompson(|) 835(|)Lucy(|)kim(|) 836(|)Iwan(|)Will(|) 837(|)Sarah (|)Good(|) what i am struggling with is i want to get rid off the last delimiter so it would be 834(|)Step(|)Thompson 835(|)Lucy(|)kim 836(|)Iwan(|)Will 837(|)Sarah (|)Good i have tried using // while loop to loop through selected fields while ($row = mysql_fetch_array($new)) { foreach ($sam[0] as $v) { $test = $row[$v] . $DELIMITER; echo substr($test, 0, -1); } echo "<br />"; } but this gets rid off the delimiter for all off them??? This will output the following . 834Stephompson 835Lucykim 836IwanWill 837SarahGood ideally i would like each row to be its own stored together. Any Help Please Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted March 10, 2011 Share Posted March 10, 2011 Since you're only using certain fields from the DB, you should only be selecting those field, which makes the logic much easier: <?php $q = "select id,firstname,lastname from {$DB_TABLE}"; $rs = mysql_query($q); $tmp = array(); while ($row = mysql_fetch_array($rs, MYSQL_NUM)) { $tmp[] = explode($DELIMITER, $row); } echo explode("<br />\n",$tmp) . "<br />\n"; ?> Ken Quote Link to comment Share on other sites More sharing options...
isimpledesign Posted March 10, 2011 Author Share Posted March 10, 2011 thanks kenrbsn your code helped loads i ended up using this. // querys the database $new = mysql_query("SELECT {$ROWS} FROM {$DB_TABLE}"); // while loop to loop through selected fields while ($row = mysql_fetch_assoc($new)) { $tmp = array(); $tmp[] = implode($DELIMITER, $row); echo $tmp[0] . "<br />"; } legend Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted March 10, 2011 Share Posted March 10, 2011 If you're using the array within the loop, you don't need the array at all, just do <?php while ($row = mysql_fetch_assoc($new)) { echo implode($DELIMITER, $row) . "<br />"; } ?> Ken Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.