[SOLVED] getting a list in order - quicky

[aebstract]

I have a lot of items in a database and when I go to pull them out and display them in the browser, I want to put them in order by their "loc" number. What it is doing is putting them in the following order:

 

1,10,11,12,13,14,15,16,17,18,19,2,20,21, etc...

 

what I want it to display as is:

1,2,3,4,5,6,7,8,9,10,11,12,13,14,15, etc..

 

the code:

$result2 = mysql_query("SELECT * FROM parts WHERE MCHN='PH' ORDER BY LOC") or DIE(mysql_error());

while($r2=mysql_fetch_array($result2)) 
{ 
$loc=$r2["LOC"];
$pn=$r2["PN"];

$parts .= "$loc - $pn<br />";


}

[drummer101]

$result2 = mysql_query("SELECT * FROM parts WHERE MCHN='PH' ORDER BY LOC ASC") or DIE(mysql_error());

[aebstract]

Hrm, makes sense to me to put that in (my bad for missing it) but it still didn't order it correctly?

[aebstract]

Changed the column in the table to be an integer and it fixed the problem.