$result = mysql_query("SELECT * FROM artist_profiles ORDER BY points DESC",$db);
while ($myrow = mysql_fetch_row($result)) {
$id= "$myrow[0]";
$type= "$myrow[3]";
$artist= "$myrow[2]";
$city= "$myrow[5]";
$state= "$myrow[6]";
$points= "$myrow[16]";
$image= "$myrow[19]";
$bio= "$myrow[11]";
}
basicly what the problem is - is that I'm attempting to retrieve all the data from a database. I want to sort the data by points, and list them from greatest to least (descending order).
Currently SQL is only returning them in ASC or ascending order. Any help is much appreciated and thanks in advance!
