Removing trailing comma in loop?

[RetroDreams]

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

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


Here is what is in the rank_otherbits template

PHP Code:

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

Originally Posted by Boofo

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?

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


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 [DATE]1207013300[/DATE] at [TIME]1207013300[/TIME] ---------------

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?