I'm trying to do a dynamic update function but got stuck.
Code: Select all
//create query
foreach($values as $value) {
$mysql_escape .= mysql_real_escape_string($value, $link).", ";
$vals .= "%s, ";
}
$mysql_escape = substr($mysql_escape, 0, -2);
$vals = substr($vals, 0, -2);
//MySQL query
$query = sprintf("INSERT INTO ".$mySQLtable." () VALUES (".$vals."), ", $mysql_escape);However I don't know how to store it properly so i get an error:
I know it's a simple fix but don't know how to do it.Warning: sprintf() [function.sprintf]: Too few arguments in C:\wamp\www\test\test.php on line 68
Thanks