[請益] PHO INSERT 資料到mysql

[kaoshi (Catling)]

估狗了很久
發現沒有這樣做
但實在很想試試看= =|||


我需要一次新增資料到3個表格

$SQL = " INSERT INTO stock";

$SQL = $SQL . " (stock_id, stock_nm, price) VALUES ";

$SQL = $SQL . " ('$stock_id', '$stock_nm','$price');";

$SQL = $SQL . " INSERT INTO pic";

$SQL = $SQL . " (pic_id, pic1) VALUES ";

$SQL = $SQL . " ('$stock_id','$pic1'); ";

$SQL = $SQL . " INSERT INTO standard";

$SQL = $SQL . " (std_id, epa) VALUES ";

$SQL = $SQL . " ('$stock_id','$epa') ";


結果出現

ERROR: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO pic (pic_id, pic1) VALUES
('abc123','http://images.ecarlist.com/p' at line 1 INSERT INTO stock
(stock_id, stock_nm, price) VALUES ('abc123', '2000 TOYOTA CAMRY','545');
INSERT INTO pic (pic_id, pic1) VALUES
('abc123','http://images.ecarlist.com/photos/995_278530/80/33.jpg'); INSERT
INTO standard (std_id, epa) VALUES ('abc123','aqwdeqd')


但是我直接把
INSERT INTO stock (stock_id, stock_nm, price) VALUES ('abc123', '2000 TOYOTA
CAMRY','545'); INSERT INTO pic (pic_id, pic1) VALUES
('abc123','http://images.ecarlist.com/photos/995_278530/80/33.jpg'); INSERT
INTO standard (std_id, epa) VALUES ('abc123','aqwdeqd')
再PHPMYADMIN輸進去
卻可以成功


想請問 到底是為甚麼呢?>"<
有沒有甚麼辦法可以解決@@
謝謝 (不知道問題有沒有很白目~"~)

--
C'est La Vie
http://www.wretch.cc/album/ringle

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 76.187.11.47
→ appleboy46  :echo $SQL 然後在丟進去 phpMyAdmin 試試看
→ kaoshi      :echo $SQL出來的東西輸入phpmyadmin也是成功的 但php
→ kaoshi      :輸入MYSQL就不行~"~
推 chph        :http://tw2.php.net/mysqli.multi-query
推 dspswen     :欄位先加個``
→ tkyifang    :chph真原因
→ thitbbeb    :也許是編碼問題…我也有遇過…UTF-8的小問題
推 PHP5        :mysql_query() sends a *unique* query
→ PHP5        :(multiple queries are not supported)