IF EOF then remove the ,?

[jarv]

hi, I have a list of keywords, is there a way of removing the ,(comma) at the end of the line?

Also how would i go about linking on the keywords?

 

while($row1 = mysql_fetch_array($result2))
      {
      $Keyword = $row1['keyword'];
  $KeywordID = $row1['keyword_id'];
       echo $Keyword;echo ', ';
       }

[Jabop]

<?php
$var=substr($var,0,-2);
?>

 

You can link stuff using the a href html tag.

[thebadbad]

Example:

 

<?php
$keyword_str = '';
while ($row1 = mysql_fetch_array($result2)) {
$keyword_str .= '<a href="keyword.php?id=' . $row1['keyword_id']; . '">' . $row1['keyword'] . '</a>, ';
}
echo substr($keyword_str, 0, -2);
?>

 

Will output comma (and space) separated links, linking to keyword.php?id=id_here

substr() removes the last comma and space from the string.

[jarv]

sorry I don't understand $var=substr($var,0,-2);

[thebadbad]

substr() returns a part of a string. substr($var, 0, -2) returns the string $var 2 characters shorter (cutted from the end). It's free to check the manual, you know?

[sasa]

try

<?php
$start = true;
while($row1 = mysql_fetch_array($result2))
{
      $Keyword = $row1['keyword'];
      $KeywordID = $row1['keyword_id'];
      if ($start) $start = false; else echo ', ';echo $Keyword;
       }
?>