[SOLVED] RTRIM not working

[greenday]

For some reason my right trim is not cutting off the last comma in the sql statement, can anyone  help please??

 

<?php if(isset($_POST["submit"])){

mysql_select_db($database_admin, $admin);
$updatedeleted=("UPDATE listtable SET ");

If($_POST['main_checkbox'] == '1') {
$updatedeleted = $updatedeleted . " mainpic='noimage.gif', ";
}
If($_POST['2_checkbox'] == '1') {
$updatedeleted = $updatedeleted . " pic2='noimage.gif', ";
}
If($_POST['3_checkbox'] == '1') {
$updatedeleted = $updatedeleted . " pic3='noimage.gif', ";
}

// Trim off the last commer
$sql = rtrim($updatedeleted,",");

$updatedeleted = $updatedeleted ."WHERE listtable.address='33 long lane'";

mysql_query($updatedeleted);

echo $updatedeleted;

}
?>

[corbin]

You set $sql, but you never use it.... I think you're meaning to assign what you're assigning to $sql to $updatedeleted. ;p

[darkfreaks]

$updatedeleted = $sql ."WHERE listtable.address='33 long lane'";

[greenday]

great, thanks corbin and darkfreaks, works great 

[darkfreaks]

post the final code and close it

[greenday]

<?php if(isset($_POST["submit"])){

 

mysql_select_db($database_admin, $admin);

$updatedeleted=("UPDATE listtable SET ");

 

If($_POST['main_checkbox'] == '1') {

$updatedeleted = $updatedeleted . " mainpic='noimage.gif', ";

}

If($_POST['2_checkbox'] == '1') {

$updatedeleted = $updatedeleted . " pic2='noimage.gif', ";

}

If($_POST['3_checkbox'] == '1') {

$updatedeleted = $updatedeleted . " pic3='noimage.gif', ";

}

If($_POST['4_checkbox'] == '1') {

$updatedeleted = $updatedeleted . " pic4='noimage.gif', ";

}

If($_POST['5_checkbox'] == '1') {

$updatedeleted = $updatedeleted . " pic5='noimage.gif', ";

}

If($_POST['6_checkbox'] == '1') {

$updatedeleted = $updatedeleted . " pic6='noimage.gif', ";

}

 

// Trim off the last commer

$updatedeleted = rtrim($updatedeleted," , ");

 

$updatedeleted = $updatedeleted ." WHERE listtable.address='33 long lane'";

 

 

 

mysql_query($updatedeleted);

 

echo $updatedeleted;

 

}

?>