<?php $query = mysql_query("SELECT * FROM users WHERE pointsAvailable > 0 ORDER BY pointsAvailable Desc"); $queryResultArray = mysql_fetch_array($query); foreach($queryResultArray as $row) { echo $row['pointsAvailable']; } ?>