$row[help]!

[Anon]

Im new to php syntax...anyway

"select ID from ratings order by overall_rating DESC"

when i run this sql command in phpMyAdmin it returns:

2,3,1

I am trying to get that 2,3,1 into an array, like $row[0] would = 2, $row[1] would = 3 etc.

However, if I do mysql_fetch_row on that query, only row[0] has a value.

Any way to get this data into an array so i can call it later? any help appreciated, thanks...

[fitzbean]

It's because you are only selecting the ID field.. SELECT * FROM ratings order by overall_rating DESC

[Anon]

insted of using mysql_fetch_row why don't you use mysql_fetch_object ?? or mysql_fetch_array ??
<?php

$sql="select ID from ratings order by overall_rating DESC";
$result=mysql_query($sql);
while($row=mysql_fetch_object($result))
{
echo($row->ID);
}

?>

[Anon]

That helps, in my database, that echos out 231 ... now how would I get this in an array, like $row[0] would = 2, $row[1] would = 3, row[2] would = 1, etc... thanks for the help

[Anon]

<?php

$sql="select ID from ratings order by overall_rating DESC";
$result=mysql_query($sql);
while($row=mysql_fetch_object($result))
{
$row2[]=$row->ID;
}

//now $row2[0] will be 2 and so on..
?>