[SOLVED] Trouble getting info from a column

[sd9sd]

I have a table like this:

---------------------------------------

order       |       rating        |     name

---------------------------------------

  0          |        543          |      abc

  2          |        34            |      dfwe

  8          |        45            |      ssf

---------------------------------------

 

I need to get the contents of the 'order' column into an array like so:

echo $orderNumbers[0]; //traces 0

echo $orderNumbers[1]; //traces 2

echo $orderNumbers[2]; //traces 8

 

This is the php code I'm using unsuccessfully:

$query = mysql_query("SELECT * FROM `data`");

while($row = mysql_fetch_array($query)){$result=$row['order'];}
$result=explode(",",$result);
echo "length of array=".count($result)."<br>";
for($i=0;$i<count($result);$i++) {echo "$result[$i] <br>";}

Could anyone show me the right query to get the data please?

[sd9sd]

Apologies...topic got solved faster here http://www.phpfreaks.com/forums/index.php/topic,204794.html

[fenway]

So you double-posted... that's a no-no.

[sd9sd]

sorry...won't happen again.