亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

老師，這是我創建的一張名為order的表，下面是form表單

<form method="post" action="doAction.php?act=order">

<table border="0" width="400px" class="tb">

<tr><td colspan="2"><h3>填寫訂單：</h3></td></tr>

<tr height="40px">

<td width="100px">預訂人：</td><td><input type="text" class="txt" name="orderName" value="<?php echo $_SESSION['username'];?>"/></td>

</tr>

<tr height="40px">

<td>房間類型：</td><td><input type="text" ?class="txt" name="orderType" value="<?php echo $row['rName'];?>"/></td>

</tr>

<tr height="40px">

<td>入住日期：</td><td><input type="date" class="txt" name="liveDate" /></td>

</tr>

<tr height="40px">

<td>離開日期：</td><td><input type="date" class="txt" name="leaveDate" /></td>

</tr>

<tr height="40px">

<td>房間數量：</td><td><select name="orderNum"><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option></select>&nbsp;間</td>

</tr>

<tr height="40px">

<td>聯系電話：</td><td><input type="text" class="txt" name="tel" value="<?php echo$row1['tel'];?>"/></td>

</tr>

<tr height="40px">

<td>確認方式：</td><td><select class="txt" name="confirmType"><option value="0">電話確認</option><option value="1">郵件確認</option></select></td>

</tr>

<tr>

<td>特殊要求：</td><td><textarea cols="30" rows="5" name="require"></textarea></td>

</tr>

</table>

<p></p>

<input type="submit" class="orderBtn bt1" value="提交訂單" />

</form>

下面是doAction.php

elseif($act=="order"){

$orderName=$_POST['orderName'];

$orderType=$_POST['orderType'];

$liveDate=$_POST['liveDate'];

$leaveDate=$_POST['leaveDate'];

$orderNum=$_POST['orderNum'];

$tel=$_POST['tel'];

$confirmType=$_POST['confirmType'];

$require=$_POST['require'];

$sql="insert order(orderName,orderType,liveDate,leaveDate,orderNum,tel,confirmType,require) values('$orderName','$orderType','$liveDate','$leaveDate','$orderNum','$tel','$confirmType','$require') ";

$result=mysql_query($sql) or die(mysql_error());

if($result){

echo"<script>alert('生成訂單成功，您可以在會員中心查看您的訂單！');window.parent.location='huiyuancenter.php';</script>";

}else{

echo"<script>alert('生成訂單失敗，請重新預訂！');window.parent.location='order.php';</script>";

}

}

為什么不能把數據導入到order表中，錯誤提示：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 'order(orderName,orderType,liveDate,leaveDate,orderNum,tel,confirmType,require) v' at line 1

這是什么意思？？？是數據庫出錯了么？