Array and implode problem

[damo87]

My query in the code below returns two rows (from my MySQL database), which it should do.  If I loop through the results, I can disply the two rows.  What I need to do is these two to be in a new variable, comma separated so that I can use them in an insert statement.

 

What I get with the code below is only the first row. If I print the array before I try to implode it, I get:

 

Array ( [number] => 1 )

 

So it looks like I'm not setting up the array correctly because the '1' is the value of the first row, but the value of the second row is missing.

 

Any suggestions for getting both values into the array, and them imploding them would be greatly appreciated!

 

$query= "Select round from rounds where rounds.round<=$roundineditable and rounds.round not in (select x from margin where user=$user and round<=$roundineditable)";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$row = mysql_fetch_assoc($result) or die(mysql_error());
$comma_separated = implode(",", $row);
echo "<p>$comma_separated</p>";

 

[vividona]

while($row = mysql_fetch_assoc($result)){
//code here
}

[damo87]

Thanks for the push in the right direction. Got it to work like this:

 

$queryrounds = "Select number from ...........rest of query here"; 
$resultrounds = mysql_query($queryrounds) or die (mysql_error());
while($row = mysql_fetch_object($resultrounds)){
$rounds_array[] = $row->number;
}
$rounds_list = implode(", ", $rounds_array);
echo "Hello: $rounds_list";