echoing associative array as csv; how to omit last comma

[rubing]

hey friends,

 

I am using php to display all results from my table as a comma seperated string.  However I don't want the comma after the last result.  Should I just use string substition to eliminate the last character?

 

while ((($row = $result->fetch_assoc()) !== NULL) && ($i < $limit)) 

			{
				$clip=$row['mp3id'];
				$clip ="http://www.example.com/musicserve.php?id=".$clip;
				echo $clip . ",";
				++$i;
			}

[JonnoTheDev]

No. Store the values into an array and then implode as a string:

 

$values = array();
// your while loop
while($row = $result->fetch_assoc()) {
$values[] = $row['mp3id'];
}
print implode(",", $values);

[rubing]

Awesome! 

 

 

I knew string substition was an ass backward approach!