Converting varchar for Query Result

ndorfnz2

Here's the deal...

I have a select box displaying values from a mysql table, the column is varchar.

I am sorting ASC... I want the values to be sorted "numerically"

For example, the values I am storing are range from 1 - 26.2

For example these values are being displayed as:
1, 12.4, 13.1, 2, 26.2, 3

I want:
1, 2, 3, 12.4, 13.1, 26.2

Any clues how to modify my SQL statement to handle this??

Appreciate the input!!

For an example, click the distance select box on:
example of sorting

LordShryku

[man]natsort[/man] them. Or just don't store numbers as varchars....

ndorfnz2

Nice, thanks! Wasn't familiar with that one!!

Can it be used within a mysql_fetch_array? Made some futile attempts but no luck!!!

while ($rowD = (mysql_fetch_array($distance_sql_result))
{$distance = $rowD[distance];
$selected = '';
if ($distancesel == $distance)
{
$selected = ' selected';
}
$distance_block .="<option value=\"$distance\"$selected>$distance</option>";
}

Thanks again!

laserlight

natsort() is for PHP, so you would have to obtain the data in an array first.