simple query

keeptrying

I feel like I have lost my marbles!
I cannot seem to work out how to achieve this very simple goal!

select order_id from sd_statusalert where status_id=2

Returns me 2 id numbers, I would like my PHP to add these together then I can use them in another select. for example
Result
1234
5678
turn into 1234,5678
I'm using this at the moment but it's treating each row as separately.

while ($Get_the_Orders_row = mysql_fetch_row($Get_the_Orders))
{
   $aa  = $Get_the_Orders_row[0];  	  	
   echo $aa;
}

How can I have my code take the two results add them together into one variable so I can use that result for another query?
thanks

bpat1434

$aa = 0;
while($row = mysql_fetch_assoc($Get_the_Orders))
{
    $aa += $row['order_id'];
}

echo $aa;

keeptrying

Sorry - I've not been clear. My post is mis-leading. I dont want to mathematically add the two results together, rather I need them as they are but concatenating in the same variable.

I'd like $aa to be '1234,5678' not the sum of the two.

leatherback

$aa = '';

while ($Get_the_Orders_row = mysql_fetch_row($Get_the_Orders))
  {
   $aa  .= $Get_the_Orders_row[0];            

   echo $aa;
  }

keeptrying

thanks guys - getting closer. This is the result I get from my raw SQL select:
11672
16008

There are just two rows. When I use the code suggested by leatherback I get the following.

116721167216008

I dont know why there are three results here and why the first has repeated itself?
Also how could I split that up and put a comma between the results?
This is exactly how I would like it if I can:
11672,16008

thanks

keeptrying

I tried this:

$aa ='';
while ($Get_the_Orders_row = mysql_fetch_row($Get_the_Orders))
{

  $aa  .= ',' . $Get_the_Orders_row[0];

echo $aa;
}

Result:

,11672,11672,16008

leatherback

$aa = array();

while ($Get_the_Orders_row = mysql_fetch_row($Get_the_Orders))
  {
   $aa[]  = $Get_the_Orders_row[0];            

   } 
$aa = implode($aa, ',');
echo $aa;

// You might need to reverse the arguments in implode:
//$aa = implode(',' $aa);

keeptrying

Perfect that Leatherback - I salute you...

thanks