Loop results together

[NZ_Kiwis]

I want my results to show like this 1/43/53/22/3/76

This does not work. How can I do it?

$result2 = mysql_query ("SELECT * FROM news_area_data WHERE news_id = $SID");
while ($row2 = mysql_fetch_array($result2)) {
$value = $row2['news_area_id'];
$nastring = "$value/";    

} 

[cahva]

$result2 = mysql_query ("SELECT * FROM news_area_data WHERE news_id = $SID");
$value = array();
while ($row2 = mysql_fetch_array($result2)) {
    $value[] = $row2['news_area_id'];
} 

$nastring = implode('/',$value);

[NogDog]

Another alternative is to let MySQL do it:

$sql2 = "SELECT GROUP_CONCAT(`news_area_id` SEPARATOR '/') AS `nastring`
FROM `news_area_data` WHERE `news_id` = $SID";
$result2 = mysql_query($sql2) or die(mysql_error());
list($nastring) = mysql_fetch_row($result2);

[halojoy]

here is another version

<?php

$result2 = mysql_query ("SELECT * FROM news_area_data WHERE news_id = $SID");

$nastring = ''; // we start with empty $nastring
while ($row2 = mysql_fetch_array($result2)) {
    $value = $row2['news_area_id'];

// Add to the $nastring, we append using:   .=
$nastring .= $value . '/'; 

//Same as
// $nastring = $nastring . $value . '/';    or  
// $nastring = $nastring . "$value/";     or
// $nastring .= "$value/";

}
// remove '/' from last
$nastring = rtrim( $nastring, '/' );

if( empty($nastring) ){
    echo 'no results';
}
else{
    echo $nastring;
    // this could have been done from the beginning, in result loop
    // but if needed later
    // store result $nastring in an array $news_ids()
    $news_ids = explode( '/', $nastring );

}