Re: Inserting string - need to trim comma
| From: | Matt Matijevich | Date: | Thu, 01 Apr 2004 19:10:29 +0000 |
| Subject: | Re: Inserting string - need to trim comma | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-182059@lists.php.net to get a copy of this message | ||
<snip>
function insert($table, $data) {
$sql = "INSERT INTO ".$table." SET ";
foreach ($data as $k=>$v) {
$sql.= $k." = '".$v."', ";
}
$sql.=";";
$result = mysql_query($sql);
}
The only problem with the statement is the appended comma to each
iteration - the statement generates a mysql error with the extra comma
at
the end of the statement. This seems like an easy fix -any ideas?
Any help would be greatly appreciated...
</snip>
http://www.php.net/rtrim