Question

php写的，$res=mysql_query('SELECT * FROM consumer WHERE phone="'.$a.'"');哪里有问题

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in D:\workspace\order\center.php on line 23 这是错误提示

Answer 1

$res=mysql_query(“SELECT * FROM consumer WHERE phone=’”.$a.”‘“);
如果$a为空，sql 就是 select * from consumer where phone = '';
如果表内没有空，返回的就是false
mysql_fetch_row($res);中间的$res需要的是一个结果集类型的参数，所以报错了！
mysql_fetch_row($res);改成@mysql_fetch_row($res);应该就能屏蔽错误，再判断返回值做处理吧！或者先判断$res再mysql_fetch_row