MYSQL Write error message
$value = Array ();
foreach ($all as $cust) {
$value [] = "(' {$cust [' id ']} ', ' {$cust [' last ']} ')";
}
echo $query = "INSERT INTO cust (Cust_id,last) values". Implode (",", $value);
$db->query ($query);
will appear
You have a error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-use-near "at line 1
Excuse me, where is the wrong writing?
------to solve the idea----------------------
The number of field columns and values does not correspond
Looking at your data, you may be going to bulk insert
First look at your SQL output, it should be your organization SQL wrong
------to solve the idea----------------------
I want you to stick it out.
$value = Array ();
foreach ($all as $cust) {
$value [] = "(' {$cust [' id ']} ', ' {$cust [' last ']} ')";
}
echo $query = "INSERT INTO cust (Cust_id,last) values". Implode (",", $value);
The result, did you post it?
If it is insert into Cust (Cust_id,last) VALUES ()
That means $all is an empty array.