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 :(

// 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 :D
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.