Not adding on a loop

[NZ_Kiwis]

I have this code and it words fine but it adds a ; at the end of my $Words string

How can i remove this after the last word has been added?

$result3 = mysql_query ("SELECT * FROM regions_keywords WHERE NewsRegionID = $RegionID");
while ($row3 = mysql_fetch_array($result3)){
			$Words .= $row3['NewsKeyWord'] . "; ";
}

[bradgrafelman]

[man]rtrim/man

[batowiise]

TRY THIS

$result3 = mysql_query ("SELECT * FROM regions_keywords WHERE NewsRegionID = '$RegionID'");
while ($row3 = mysql_fetch_array($result3)){
$Words .= $row3['NewsKeyWord'] . "; ";
}

[laserlight]

I suspect that the rtrim solution would be quite efficient, but another way to do this would be:

$result3 = mysql_query("SELECT * FROM regions_keywords WHERE NewsRegionID = $RegionID");
$NewsKeyWords = array();
while ($row3 = mysql_fetch_array($result3)) {
    $NewsKeyWords[] = $row3['NewsKeyWord'];
}
$Words .= implode('; ', $NewsKeyWords);