|
 |
| |
เกี่ยวกับ INSERT INTO ครับ..Warning : Incorrect suntex near ','. (severity 15) |
| |
 |
|
|
 |
 |
|
Code (PHP)
echo $strSQL;
$objQuery = mssql_query($strSQL);
มันได้ค่าออกมาเป็นอะไรครับ
|
 |
 |
 |
 |
| Date :
2011-08-04 22:12:15 |
By :
webmaster |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
echo มาๆได้
INSERT INTO tel (tel,id_detail)VAALUES (('1),(2),(3),(4',85))
|
| |
|
|
| |
| Date :
2011-08-04 22:18:49 |
By :
MyZeus |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
implode("), (", $_POST['ddlSelect'])
ตัวนี้ใช้ insert ได้เฉพาะฟิลด์เดียว หลายๆ record ครับคุณ
|
| |
|
|
| |
| Date :
2011-08-04 22:19:47 |
By :
ikikkok |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
กำ ผมกะมาประยุกต์ใช้ แล้วมีวิธีไหนบ้างครับที่แก้ปัญหาได้
|
| |
|
|
| |
| Date :
2011-08-04 22:20:57 |
By :
MyZeus |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (PHP)
$strSQL = "SELECT * FROM tel";
$objQuery = mssql_query($strSQL) or die ("Error Query [".$strSQL."]");
if(is_array($_POST['ddlSelect']) and count($_POST['ddlSelect'])>0)
{
$strSQL ="INSERT INTO tel ";
$strSQL .="(tel,id_detail)";
$strSQL .="VALUES ";
$values = array();
foreach($_POST['ddlSelect'] as $tel){
array_push($values, "('" . $tel . "','" . $last_id . "')");
}
$strSQL .= implode(", ", $values);
}
$objQuery = mssql_query($strSQL);
|
| |
|
|
| |
| Date :
2011-08-04 22:35:42 |
By :
ikikkok |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ขอบคุณนะครับ
|
| |
|
|
| |
| Date :
2011-08-04 22:54:38 |
By :
MyZeus |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 04
|
