[SOLVED] Displaying numbers from rows in DB

[forumnz]

I want to SELECT numbers FROM a database WHERE user='user'...I know how to do that... but lets say there is 5 rows with that user... how can I display the number from each one like this 1,2,3,4,5 ? Just the numbers with a comma in between?

 

Hope this makes sense!

 

Thanks!

Sam.

[digitalgod]

$query = "SELECT....";
$result = mysql_query($query) or die(mysql_error());

while( $row = mysql_fetch_array($result) )
{
  echo $row['columnname'];
}

[forumnz]

Thanks..but what if I want it to be a variable?

Like if in the end I want $numbers to equal '1,2,3,4,5'. How is that done?

[digitalgod]

I'm not sure I understand what you mean, what columns are you selecting and what is it that you want to be displayed?

[sasa]

$query = "SELECT....";
$result = mysql_query($query) or die(mysql_error());

while( $row = mysql_fetch_array($result) )
{
  $num[] = $row['columnname'];
}
$numbers = implode(',', $num);

 

[digitalgod]

oh snap... I really am tired

 

so yeah what sasa said should do the trick

[forumnz]

Thanks everyone!