Removing trailing comma in loop?

[RetroDreams]

Originally Posted by Boofo

Above the eval, right?

Nope, here is what it looks like:

PHP Code:

$othervotes = $db->query_read("SELECT team, rankem_team.teamid, sum(points) AS totalpoints
FROM rankem_rank
INNER JOIN rankem_team ON rankem_team.teamid = rankem_rank.teamid
WHERE rankem_rank.weekid = $week
GROUP BY rankem_team.teamid
ORDER BY totalpoints DESC 
LIMIT 25,100");
if ($db->num_rows($othervotes) > 0)
{
while ($others = $db->fetch_array($othervotes))
{
eval('$otherbits .= "' . fetch_template('rank_otherbits') . '";');
}
$otherbits = trim($otherbits, ', ');
} 


[Boofo]

See? That just proves you should never listen to me.

[RetroDreams]

Originally Posted by Boofo

See? That just proves you should never listen to me.

LOL -- I was two beers in and scratching my head. I was gonna listen to anyone or anything with an idea.

http://www.goldhelmet.com/rankings.php?week=1

Here is my "progress" thus far. I'm not stuck on a new query and getting some god awful mySQL error message: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'. PC Load Letter... what the F does that mean? LOL

[Boofo]

What version of MySQL are you running?

[Dismounted]

PHP Code:

$othervotes = $db->query_read("
    SELECT team, rankem_team.teamid, sum(points) AS totalpoints
    FROM rankem_rank
    INNER JOIN rankem_team USING (teamid)
    WHERE rankem_rank.weekid = $week
    GROUP BY rankem_team.teamid
    ORDER BY totalpoints DESC 
    LIMIT 25, 100
");

if ($db->num_rows($othervotes) > 0)
{
    while ($others = $db->fetch_array($othervotes))
    {
        eval('$otherbits .= "' . fetch_template('rank_otherbits') . '";');
    }
}

$otherbits = trim($otherbits, ',');