sort in while(list($vars) = mysql_fetch_row($result))

[Verdon Vaillancourt <verdonv@xxxxxxxxx>]

Hi,

I'm running into some sorting issues using a while(list($vars) =  
mysql_fetch_row($result)). I can provide more code if needed, but  
thought I would try this little bit first to see if I'm missing a  
fundamental concept and not a detail.

In a nutshell, I have a query first..
$result = mysql_query("select id, text, url, m_order from menu where  
level = 2 && active = 1 order by m_order");

.. the result of this query is sorted correctly by m_order


Then I pass it through this..
while(list($id, $text, $url, $m_order) = mysql_fetch_row($result)) {
  $out .= "$text - $m_order \n";
}
echo $out;

.. it is now no longer in the order it was in the query. In some  
results it is, in others it's not.


Am I missing something basic?

Thanks,
verdon

Ps. Please cc me if replying as I am on digest  mode

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php