MySQL query help :)

[joecooper]

SELECT * FROM `users` ORDER BY `high` ASC LIMIT 10

 

i have the above query and it works, but i want to list the results.

 

in the table 'users', i want to list the feilds, 'username' and 'high'

 

thanks

[AP81]

SELECT username, high FROM `users` ORDER BY `high` ASC LIMIT 10

[bilis_money]

<?php

$query  = "SELECT username, high FROM users ORDER BY high ASC LIMIT 10";

 

$result = mysql_query($query) or die('Error, query failed');

 

while(list($username, $high) = mysql_fetch_array($result))

{

echo "$username, $high <br>";

}

?>