Original Post
I almost feel like my IQ is dropping a point or two just by asking.... but I'm trying to pull data from a mysql database useing php, and the code looks something like this. $r = mysql_query("select * from table order by cost asc"); The problem is, when I try to display the values of $r, it doesn't really sort by cost.... it only looks at the first number, and sorts by that instead of sorting by the entire thing. For example, the sort order will look something like: 10000 2 300 350000 4500 This, to me, is absurd. Is there any way to get it to actually sort by value? Or is this just a mysql bug? Or am I just overlooking something easy? Thanks in advance.
