get rid off the last delimiter

[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 />";

    }

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

[kenrbnsn]

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

[isimpledesign]

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

[kenrbnsn]

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