How to select a value from the least

[simon2x1]

the code below will diplay the following:

1 john
2 dave
3 mark

i want it to start from the least like this

3 mark
2 dave
1 john

$result = mysql_query("SELECT * FROM users") or die(mysql_error());
$count = 0;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)){
				
$num = $line[id];
$person = $line[user];
				
echo "$num $person";
	$count++;
	}

[JKing]

Use an order by clause in your query.

$result = mysql_query("SELECT * FROM users ORDER BY id DESC") or die(mysql_error());