$p_hotel=$db->query("SELECT user_id,orderid FROM hotel_order_details where user_id=$user_id and orderid=$order_id");
$p=mysql_fetch_array($p_hotel);
if ($p['user_id']==$user_id && $p['orderid']==$order_id)
{
//echo "<script>alert('成功 !!!');window.location='m_hotel_order_details.php';</script>";
echo '不可重复添加 !!!';
exit();
}
$p=mysql_fetch_array($p_hotel);
if ($p['user_id']==$user_id && $p['orderid']==$order_id)
{
//echo "<script>alert('成功 !!!');window.location='m_hotel_order_details.php';</script>";
echo '不可重复添加 !!!';
exit();
}
if(mysql_num_rows($rs)) echo "用户 $user_id 已存在"
$name=$_POST['name'];
$sql = "SELECT name FROM table WHERE name='$name'";
$query = mysql_query($sql);
$rows=mysql_fetch_array($query);
mysql_free_result($query);
if ($row['name']==$name) {
echo '用户名已存在,请重新输入';
eixt;
}else {
$sql = "INSERT INTO table (name, passwrod,email)
VALUES ('$_POST[name]','$_POST[passwrod]','$_POST[email]')";
}
这样写后 输出错误<br />
<b>Warning</b>: mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/var/www/2011/webroot/member/c_hotel_comment.php</b> on line <b>24</b><br />
$p=mysql_fetch_array($p_hotel);
if ($p['counts']!= 0)
{
//echo "<script>alert('成功 !!!');window.location='m_hotel_order_details.php';</script>";
echo '不可重复添加 !!!';
exit();
}