Sort "myadopts" page

[Dinocanid]

I decided to play around with it and I got it working! The refresh is a bit strange, but it works well enough. Otherwise users would have to click on the page link again to see the changes.
For the column in phpMyAdmin, you're going to have to set the default 'as defined' to one of the choices or else you'll get an error.

PHP Code:

    public function index(){
        $mysidia = Registry::get("mysidia");
        $total = $mysidia->db->select("owned_adoptables", array("aid"), "owner = '{$mysidia->user->username}'")->rowCount();
        $pagination = new Pagination($total, 10, "myadopts");
        $pagination->setPage($mysidia->input->get("page"));    
        
        //Attempting to sort!
        $sort = $mysidia->db->select("users_options", array("petsort"), "username = '{$mysidia->user->username}'")->fetchColumn();
            switch ($sort){
    case 'clicks': 
        $stmt = $mysidia->db->select("owned_adoptables", array("aid"), "owner = '{$mysidia->user->username}' ORDER BY totalclicks LIMIT {$pagination->getLimit()},{$pagination->getRowsperPage()}");
        break;
    case 'gender': 
        $stmt = $mysidia->db->select("owned_adoptables", array("aid"), "owner = '{$mysidia->user->username}' ORDER BY gender LIMIT {$pagination->getLimit()},{$pagination->getRowsperPage()}"); 
        break;
    case 'level': 
        $stmt = $mysidia->db->select("owned_adoptables", array("aid"), "owner = '{$mysidia->user->username}' ORDER BY currentlevel LIMIT {$pagination->getLimit()},{$pagination->getRowsperPage()}");
        break;
    case 'name': 
        $stmt = $mysidia->db->select("owned_adoptables", array("aid"), "owner = '{$mysidia->user->username}' ORDER BY name LIMIT {$pagination->getLimit()},{$pagination->getRowsperPage()}");
        break;
}
        
        //Sorting ends here!
        $this->setField("pagination", $pagination);
        $this->setField("stmt", new DatabaseStatement($stmt));
    } 


(myadopts.php)

PHP Code:

//This is for sorting!
         if($mysidia->input->post("sortpets")){
$choice = $mysidia->input->post("sortlist");
$mysidia->db->update("users_options", array("petsort" => $choice), "username = '{$mysidia->user->username}'");
$document->add(new Comment("<meta http-equiv='refresh' content='0;url=http://YOURSITE.com/myadopts' />")); 
}
         
        $sortForm = new Form("sortform", "", "post");
        $sort_list = new DropdownList("sortlist");
        $sort_list->add(new Option("Clicks", "clicks"));
        $sort_list->add(new Option("Gender", "gender"));
        $sort_list->add(new Option("Level", "level"));
        $sort_list->add(new Option("Name", "name"));
        $sortForm->add(new Comment("<b>Sort by:</b>", FALSE));
        $sortForm->add($sort_list);
        $sortForm->add(new Button("Sort Pets", "sortpets", "submit"));
        $document->add($sortForm);
        
        //Sorting ends here!!! 


(myadoptsview.php)

I might add this to the tutorials (or mods) section since it seems to be in high demand.