query problem

[sabret00the]

been playing with this query for days and despite it working almost fine, it refuses to work really fine, it refuses to pull projects without a rating and i really need it to do that, can someone help me please as i dunno where i've gone wrong

PHP Code:

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


[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?

[sabret00the]

never mind fixed it, sorry for wasting everyones time.