delete the last character of a var

[akrocks_extreme]

i have a variable ($to) and i need to remove the last character if it is a comma (,)... I'm fairly new to php so i havnt covered this yet. thanks.

[Nixon]

Hi,

$to=trim($to);

if ( substr($to, -1)=="," ) 

{ 

$length=strlen($to); 
$length--; 
$finalvariable=substr($to, $length);

}

else { $finalvariable=$to }

echo($finalvariable);

$finalvariable will be the end product, echo that or insert it into a database or whatever.

[akrocks_extreme]

thanks for the reply, but it only returns a comma... maybe because there is more than one comma in the variable?
see, here is how it looks before we strip that last comma

[e-mail],[e-mail],[e-mail],

the email addresses are pull out of a database...

here is a small chunk of my code...

$subject = $_POST['subject'];
$message = $_POST['message'];

 $result=mysql_query("SELECT * FROM affiliates", $connection);  //Selects all entries from table users
 while($query_data = mysql_fetch_row($result))  //Selects the first row of returned results
  {
          echo ("$query_data[9]<br>");
        $to .= $query_data[9] . ",";
  }
echo ($to);
$to=trim($to);

if ( substr($to, -1)=="," )

{

$length=strlen($to);
$length--;
$finalto=substr($to, $length);

}

else { $finalto=$to; }

echo("<br>Final $finalto");

then, we mail the message using mail() to all of the addresses..

[Nixon]

$subject = $_POST['subject']; 
$message = $_POST['message']; 

 $result=mysql_query("SELECT * FROM affiliates", $connection);  //Selects all entries from table users 
 while($query_data = mysql_fetch_row($result))  //Selects the first row of returned results 
  { 
          echo ("$query_data[9]<br>"); 
        $to .= $query_data[9] . ","; 
  } 
echo ($to); 
$to=trim($to); 

if ( substr($to, -1)=="," ) 

{ 

$length=strlen($to); 
$length--; 
$finalto=substr($to,0,$length); 

} 

else { $finalto=$to; } 

echo("<br>Final $finalto");

That should work.

[akrocks_extreme]

yup, i also found that as problem... thanks alot for your help! thank goodness for the php manual online!😃