[請益] 請幫我看看是否是SQL出了問題..
我是用Dreamweaver來寫PHP的網頁
今天寫了一段SQL做一個資料集，
在SQL測試裡都沒有問題，
在phpMyadmin做查詢也沒有問題
但是一開網頁預覽就出現錯誤訊息，且錯誤的點都是在那段SQL語言上
錯誤訊息是:
Parse error: syntax error, unexpected T_STRING in
C:\AppServ\www\PlantName\test.php on line 33
PHP的程式碼為:
mysql_select_db($database_PlantName, $PlantName);
$query_Recordset1 = "SELECT `total_SP`.`code`, `total_SP`.`family`,
`char_Family_vol`.`ch-family`, `simname`.`simple-name`,`com_name`.`comname`,
`com_name`.`type2` FROM `char_Family_vol` INNER JOIN ((`com_name` INNER JOIN
`total_SP` ON `com_name`.`code` = `total_SP`.`code`) INNER JOIN `simname` ON
`com_name`.`code` = `simname`.`code`) ON `char_Family_vol`.`family` =
`total_SP`.`family` WHERE (((`simname`.`type`) Like "M") AND
((`com_name`.`type`) Like "Ch")) ";
$Recordset1 = mysql_query($query_Recordset1, $PlantName) or
die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
請問會是哪邊有問題呢?
謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.112.52.207
推
07/29 18:42, , 1F
07/29 18:42, 1F
※ 編輯: Oedogonium 來自: 140.112.52.207 (07/29 18:48)
→
07/29 18:48, , 2F
07/29 18:48, 2F
推
07/29 18:49, , 3F
07/29 18:49, 3F
→
07/29 18:50, , 4F
07/29 18:50, 4F
→
07/29 18:51, , 5F
07/29 18:51, 5F
→
07/29 18:55, , 6F
07/29 18:55, 6F
推
07/29 19:47, , 7F
07/29 19:47, 7F
→
07/29 23:47, , 8F
07/29 23:47, 8F
→
07/29 23:47, , 9F
07/29 23:47, 9F
推
07/31 15:16, , 10F
07/31 15:16, 10F
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
