[SOLVED] Trouble getting info from a column

[sd9sd]

I have a table like this:

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

order       |       rating        |     name

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

  0          |        54            |      tom

  2          |        34            |      dick

  8          |        45            |      harry

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

 

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

echo $orderNumbers[0]; //prints 0

echo $orderNumbers[1]; //prints 2

echo $orderNumbers[2]; //prints 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 way to get the data please?

[mmarif4u]

Are you want to count rows for order column.

if yes you can use mysql_num_rows.

[themistral]

Try this

 

while($row = mysql_fetch_array($query)){
    echo $row['order'];
}

It will return the order column

[whiteboikyle]

hmm why not just do a

for($i = 0; mysql_num_rows($result); $i = $i + 1;){

$order = mysql_result($result, $i, "order");

}

 

its not an array but it can get you the number of each row.. like row 1 row 2.. etc

[sd9sd]

Thanks themistral and marif4u!

It worked....my mistake with the array.

Thanks again

 

Thanks whiteboikyle...that's one solution that'll be useful for me too.

P.S: a friendly hint from me - you can try using $i++ in the for loop, instead of the $i=$i+1;