Need to display database field by DESC but it's not working
I am trying to order pages by there average rating and it is working however I am also trying to have the latest page rated be the one displayed, however the entry that is being displayed for my "pageURL" is always the first one in the database no matter what I have put in. This is the code for the recordset...
$query_rsRATINGS = "SELECT ARTISTusername, pageURL, FORMAT(AVG(rating), 2) AS averageRating FROM rating GROUP BY ARTISTusername ORDER BY averageRating DESC, pageURL DESC";
$rsRATINGS = mysql_query($query_rsRATINGS, $con2com) or die(mysql_error());
$row_rsRATINGS = mysql_fetch_assoc($rsRATINGS);
$totalRows_rsRATINGS = mysql_num_rows($rsRATINGS);
So how can I have the latest "pageURL" uploaded be the one that is displayed? I have also tried removing the pageURL DESC command but it does the same thing.