Removing trailing comma in loop?

[RetroDreams]

I've got a ranking script using the query below.

$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') . '";');
}
}

Here is what is in the rank_otherbits template

$others[team] $others[totalpoints],

As you can guess, there is a trailing comma. Is there a template conditional I can use to strip the last comma? If not, how can I do so programatically?

[Boofo]

Try:

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

[RetroDreams]

Try:

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

Pardon my ignorance, but where exactly is it placed? I've put it before, in and after the loop and nothing formats correctly.

[Boofo]

After.

[RetroDreams]

Like so, right?

$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);

Here it is in action... it duplicates the list and adds a space.

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

[Boofo]

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

Sorry

[RetroDreams]

Hmm, still no go. Wondering if it is something wrong with my if statement.

[Boofo]

Put this above the eval:

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

[RetroDreams]

No go. Duplicates the list numerous times. I tried without the . as well and it just prints like n number of ,s and then the list as it did before.

--------------- Added 1207013300 at 1207013300 ---------------

Got it. I placed $otherbits = trim($otherbits, ', '); after the loop and it got the rangly rascal! Thanks for the gentle kick in the arse!

[Boofo]

Above the eval, right?

[RetroDreams]

Above the eval, right?

Nope, here is what it looks like:

$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]

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]

$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, ',');