Wrong "order by" results
Posted on 2006-07-07
I have the following Perl code that takes the data from MySQL and sorts it:
$querystr = "select ID,Name,Description,PictureURL,InformationURL,Rate,10_Min,20_Min,Connect from $Table_Name order by 10_Min desc,Rate asc,Connect asc";
$sth = &sql($querystr);
For some reason the sorted results look like this (field 10_Min):
Why is 1342 not on top of this list and what do I need to do to change in the code to have 1342 on top?