Jump to content

Archived

This topic is now archived and is closed to further replies.

AcidRainZ

I want to add sort codes here

Recommended Posts

Please help guys on the codes i want to sort the list to highest scores to the lowest.it is currently sorting by name not by scores

 

 

heres the code:

<?php
$scores = new Pod("song_scores");
$whichsong = pods_url_variable('last');
$params = array();
$params['select'] = 't.name, t.score, t.date_played';
$params['where'] = 't.song_url LIKE "%'.$whichsong.'%"';
$params['limit'] = 10;
$scores->findRecords($params);
$total_scores = $scores->getTotalRows();
?>
<?php
   if($whichsong == "" || (strlen($whichsong)<3)){
         echo '<div id="top-score">';
         echo "This tab displays scores only in the individual songs page.";
         echo '<br />Please click <a href="';  
         $permalink = the_permalink();
         echo '">here</a> to view the scores.';
         echo '</div>';         
   }
   else{
      if($total_scores>0){
         echo '<div id="top-score">';   
         echo '<div id="top-score-header"><div class="top-score-name">Name</div><div class="top-score-score">Score</div><div class="top-score-date">Date Played</div></div>';   
         echo '<ol>';
         while ( $scores->fetchRecord() ) {
            echo  '<li><div class="top-score-name"><a href="/members/'. $scores->get_field("name") .'/profile/">' . $scores->get_field("name") . '</a></div><div class="top-score-score">' . $scores->get_field("score") . '</div><div class="top-score-date">' . $scores->get_field("date_played") . '</div>';
         }   
         echo "</ol>";      
         echo "</div>";
      }
      else{
         echo "No scores for this song has been uploaded yet.";
      }
   }
?>

 

MOD EDIT: code tags added.

Share this post


Link to post
Share on other sites

in your query why dont you add an ORDER by t.score DESC clause

Share this post


Link to post
Share on other sites

When posting code, enclose it in

 . . . 

BBCode tags.

Share this post


Link to post
Share on other sites

Well in your $params array it looks like you are building a mysql query but you never actually call it in the code that you have posted

Share this post


Link to post
Share on other sites

Did you write the code in the OP?

Share this post


Link to post
Share on other sites

OP?

 

Original Post.

 

im using it under wordpress platform

 

I don't mean to sound rude or anything, but you might be creating more work for yourself than you need to be if you're building something into wordpress... wordpress platform. Did you RTFM?

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.