Robbie
21-01-2008, 07:05 PM
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.
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.