YET ANOTHER PROBLEM (a)

[Robbie]

Sorry lol.

OK I want to show rows in order of a certain row. E.G

<?
                            $query = " SELECT *
FROM `mytable`
ORDER BY `mytable`.`number` ASC
LIMIT 0 , 70  ";
$result = mysql_query($query) or die (mysql_error()."<br />Couldn't execute query: $query"); 
$numrows = mysql_num_rows($result);

But it doesnt show the rows in order of the colum with 'number' that has the largest?

Help? Thanks.