A string = the outcome of my query

[npsari]

Hello, i know this is not my first question today, however, i am facing a small problem here

 

I want to create a string which is equal to the whole outcome of my query

 

This is my Query...

$q = "SELECT * FROM code WHERE code_key LIKE '%{$key}%'  ORDER BY RAND() ";
$res = @mysql_query($q,$con); 
while($r = @mysql_fetch_array($res)){
print "$r['code_id'],";
}

 

The result is

 

445,556,554,333,222,44,55,66,777

 

I want to make $sting equals this outcome

 

So, $string = "445,556,554,333,222,44,55,66,777";

 

therefore, if i echo string, i will see  this

 

445,556,554,333,222,44,55,66,777

 

Please help me, is this possible? how

[GingerRobot]

I think you're looking for implode. Something like:

 

$array = array();
while($r = @mysql_fetch_array($res)){
    $array[] = $r['code_id'];
}
$string = implode(',',$array);
echo $string;

[npsari]

The problem is how can i make a string (or an array) equals to these results from my query

 

I mean, i dont know how to create the array from the query, which will be like that

 

$array = array('445', '556', '554', '333', '222', '444', '55', '66', '77');

[npsari]

Ohh, i done it now thanks to you, many thanks