Jump to content

get rid off the last delimiter


isimpledesign

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

    }

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

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.

×
×
  • 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.