Help into value merging

cedricm

Hello everybody,

I need to merge a multiple sql selection into one value:

$sql2 = "SELECT DISTINCT(product_id) FROM **** Where user_session='$session_id'";
$query2 = mysql_query($sql2) or die("Séléction des données impossible.<br>" . mysql_error());
while($iresult = mysql_fetch_array($query2)) {
$product_id = $iresult["product_id"];
// Affichage du produit

$sql = "SELECT P.ProductID, PD.LocaleID, PD.Description as ProductDescription, P.ProductDescription as ProductDescriptionSm, P.ManufacturerID, MV.Text as ManufacturerName, P.ManufacturerPartNum as .........
$sql .= "WHERE P.ProductID ='$product_id' ";

$sql_query = mysql_query($sql) or die("Séléction des données des produits impossible.<br>" . mysql_error());

while ($sql_request = mysql_fetch_array($sql_query)) {
$ProductID = $sql_request["ProductID"];
$ManufacturerName = $sql_request["ManufacturerName"];

$content="$ProductID, $ManufacturerName<br>"";
}
}

$value="$content";

$content gives a lot of values (ex:
)

12345, wils 
32343, pins 
62340, chine .................

Now the question: how to merge these results into 1 value, to easier include this unique value.

Thanks a lot for your help and sorry for my english

swr

Instead of typing

$content = "$blah ";

try

$content .= "$blah ";

which means "append $blah to $content".

Is that what you want? It's not entirely clear what you mean by "merge these results into 1 value" so I'm kinda guessing.