public function getNumberOfSelectedRows_OLD()
{
$STM = $this->dbh->query("SELECT COUNT(*) FROM vm_composition_info  INNER JOIN users ON users.id=vm_composition_info.composition_user_id WHERE vm_composition_info.composition_status=1 AND vm_composition_info.composition_type<=2 AND users.status=1");
$r=$STM->fetchColumn();
return $r;
}
 
public function getNumberOfSelectedRows($category)
{
if($category==0)

$out_list.="<div class=\"row\"><div class=\"col-md-2\"><a href=\"../users/profile.php?u=".$row['composition_user_id']."\"><img class=\"test\" style=\"width:55px; height:55px; margin-top:5px;\"
src=\"$user->avatar\"></a></div><div class=\"col-md-10\"><a href=\"../music/music.php?id=".$row['composition_pk']."&tl=".$compo_title."\"><h3 style=\"margin-top:0px; margin-left:-40px;\">".$row['composition_title']."</h3></a><p style=\"margin-top:0px; margin-left:-40px;\"><a href=\"../users/profile.php?u=".$row['composition_user_id']."\">".$row['display_name']."</a> | views: ".$row['composition_views_count']." | tags : ".$row['composition_tags']." </p></div></div><div class=\"row\"><div class=\"col-md-12\"><hr></div></div>";
}
 
// total items
 
$objComposition_1 = new DataManager();
$total_items=$objComposition_1->getNumberOfSelectedRows();
 
// Uses the creativePager to build the navigation system of the data