[sabret00the]

fixed it

PHP Code:

            switch ($view) 
             { 
                 case "latest":
                     $group = "GROUP BY confessions.confessionid";
                     $order = "ORDER BY confessions.confessionid DESC";
                     $limit = "LIMIT 10";
                 break;
                 case "random":
                     $group = "GROUP BY confessions.confessionid";
                     $order = "ORDER BY RAND(confessions.confessionid)";
                 break; 
                 case "votes":
                     $group = "GROUP BY confessions.rate";
                     $order = "ORDER BY confessions.rate DESC, confessions.confessionid DESC";
                 break;  
                 default:
                     $group = "GROUP BY confessions.confessionid";
                     $order = "ORDER BY confessions.confessionid DESC";
                     $limit = "LIMIT " . ($minlimit-1) . ", $perpage"; 
             }
 
 
 
             // extracts confessions for main confession page
             $confessions = $DB_site->query("
                 SELECT COUNT(*) AS votes, confessions.confessionid,
                 confessions.text, confession_rate.rate, confessions.timestamp,
                 user.username
                 FROM confessions
                 LEFT JOIN confession_rate ON (confessions.confessionid = confession_rate.confessionid)
                 LEFT JOIN user ON (user.userid = confessions.userid)
                 $clause
                 $group
                 $order
                 $limit 
             "); 


but now the data i was counting don't show, any suggestions on what i should do?