hi,

i'm trying to use the left() function to remove an additional comma at the end of a string but it won't parse. Here is a section of code that is trying to pull column names and then gets placed into an Insert statement.

$get_columns=$new_db->query("explain grades");

while($row=$new_db->fetch_row($get_columns))
{
//an index to loop through the column names
$i=0;
$column_name=$row[$i];

//create a table to list all of the current columns
$names .="$column_name,";

//increment index to go to the next column name
$i++;
}

$msg=left($names, len($names)-1);
$newmsg="Insert into grades("$msg")...........";

Is there something that has to be included so the parser knows what the left function is and is there maybe a better way to remove the last comma?


I would appreciate any help,
KurtM

I think your problem is the line:

$newmsg="Insert into grades("$msg")...........";

Try

The speech marks are the start and stop markers for you string. If you want to use one inside a string you have to place the backslash infront of them to tell the parser not to see them as actual code.

Hope that helps

Hello Kurt,

Sorry I haven't had the time to go through your issues in the PHP forum recently but I can quickly post an alternative solution you can try:

use the rtrim() function to remove the last comma... like this: