Wrong results when using Order By

[dmccabe]

Can anyone tell me why regardless of which way I order the info retreived the database the "Scanner" always comes out on top?

				<?php
					$sql = "SELECT ASSET_TYPE_ID, ASSET_TYPE_NAME FROM tblassettype ORDER BY ASSET_TYPE_NAME ASC"; 
					$result=mysql_query($sql);

					while ($row=mysql_fetch_array($result)) { 
					$id=$row["ASSET_TYPE_ID"]; 
					$name=$row["ASSET_TYPE_NAME"]; 
					echo "<option VALUE=\"$id\">".$name."</OPTION>";

				} ?>

 

Contents of table:

 

1 Monitor

      2 Laptop

      3 PC

      4 Printer

      5 Switch

      6 Router

      7 Scanner

      8 Server

      9 KVM

      10 Tape Drive

 

Yet regardless of if the table is sorted ASC or DESC, the item 7 Scanner is either very top or very bottom of list?

[Buddski]

Do you have any other characters in front of it (ie a space)?

[dmccabe]

D'oh thanks