/***************************************************
* 发送短信和接受短信类别选择操作
*
***************************************************/
//$query1 = "SELECT * FROM send1 WHERE user like '%".$user."%' limit ".$numInfront.",".$pageSize."";
if($send == 'send1'){
//选择发送表时的处理
$query = "SELECT * FROM $send WHERE user_name like '".$user."' LIMIT ".$numInfront.",".$pageSize."";
// and user_name='".$_SESSION['name']."'";
}else if($send == 'receive') {
//选择接收表时的处理
$query = "SELECT * FROM $send WHERE mobile=$phonenumber ";
}else {
//选择有误时的处理
echo '你的选择有误!! ';
exit();
}
/***************************************************/
上面试代码!!!执行时出现这样的错误!!查询数据库出现了错误:SELECT * FROM send1 WHERE user_name like 'root' LIMIT -10,10.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 '-10,10' at line 1请高人指点!!
不为零的时候 $numInfront按原来的处理
就OK了