我得到了这个错误。。请帮我做这方面的新手。。"您的SQL语法有错误；请查看与MySQL服务器版本相对应的手册，在第1行的'orderlist'（分支、日期、pname、描述、数量）VALUES（'Harrison'、'0'）附近使用正确的语法"
这是我的代码
<?php
$host = "localhost";
$username = "root";
$password = "";
$dbname = "posharrison";
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$dbname")or die("cannot select DB");
$branch=$_POST['branch'];
$mydate=$_POST['mydate'];
$product=$_POST['product'];
$description=$_POST['description'];
$quantity=$_POST['quantity'];
$sql = "INSERT INTO 'orderlist' (branch, date, pname, description, quantity)
VALUES ('$branch', '$mydate', '$product', '$description', '$quantity')";
$result=mysql_query($sql);
if($result){
echo "Successful";
}
else {
echo "ERROR!!".die(mysql_error());
}
?>
<?php
// close connection
mysql_close();
?>
这是我的PHP代码
<!-- ################ -->
<div id="desktop">
<form action="order_submit.php" method="POST" name="myform">
Branch: <input type="text" name="branch" value="Harrison" size="10" readonly></br></br>
Date Today: <input type="text" name="mydate" size="10" readonly></br></br>
<script type="text/javascript">
<!-- //
document.forms['myform'].elements['mydate'].value = (new Date()).toUSAdate();
// -->
</script>
<div id="prod1">
Select Product:
<select name="product">
<option value="choose">----------</option>
<option value="desktop">Desktop</option>
<option value="monitor">Monitor</option>
<option value="laptop">Laptop</option>
<option value="parts">Parts</option>
</select>
</div>
<div id="prod">
<div class="desktop box" style="display:none">
Select Item:
<select name="description">
<option>AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</option>
<option>Dell corei7 2500 1gRAM 80gHDD COMBO</option>
<option>Green</option>
<option>Blue</option>
</select>
Quantity: <input type="text" name="quantity" size="8">
</div>
<div class="monitor box" style="display:none">
Select Item:
<select name="description">
<option>AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</option>
<option>monitor</option>
<option>Green</option>
<option>Blue</option>
</select>
Quantity: <input type="text" name="quantity" size="8">
</div>
<div class="laptop box" style="display:none">
Select Item:
<select name="description">
<option>AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</option>
<option>laptop</option>
<option>Green</option>
<option>Blue</option>
</select>
Quantity: <input type="text" name="quantity" size="8">
</div>
<div class="parts box" style="display:none">
Select Item:
<select name="description">
<option>AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</option>
<option>parts</option>
<option>Green</option>
<option>Blue</option>
</select>
Quantity: <input type="text" name="quantity" size="8">
</div>
</div>
<input type="submit" value="Add Order" id="button">
</form>
</div>
<!-- ############### -->
您的查询应该是这样的，未测试，
$sql = "INSERT INTO orderlist (branch, date, pname, description, quantity)
VALUES ('".$branch."', '".$mydate."', '".$product."', '".$description."', '".$quantity."')";
$result=mysql_query($sql);
尝试以下代码进行插入查询。
$sql = "INSERT INTO orderlist (branch, date, pname, description, quantity)
VALUES ('".addslashes($branch)."', '".addslashes($mydate)."', '".addslashes($product)."', '".addslashes($description)."', '".addslashes($quantity)."')";
$result=mysql_query($sql);
感谢