Question

php while($row = mysql_fetch_row($result))出错了

$sql = "SELECT * FROM movement order by $sort ASC";
$result = mysql_query($sql);
while($row = mysql_fetch_row($result))
{

echo '<tr>';
echo ("<td>$row[0]</td>");
echo ("<td>$row[1]</td>");
echo ("<td>$row[2]</td>");
echo ("<td>$row[3]</td>");
echo ("<td>$row[4]</td>");
echo ("<td>$row[5]</td>");
echo ("<td>$row[6]</td>");
echo '</tr>';
}
完全没问题

但加了 where shop=$shop 出错了
$sql = "SELECT * FROM movement where shop=$shop order by $sort ASC";
$result = mysql_query($sql);
while($row = mysql_fetch_row($result)) ....... 这行出错了
Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given
in /home/cybervalle/domains/cybervalley.com.hk/public_html/trans_report.php on line 53

请问何解
试了, 只要加 where 就出错了
where shop=shop1 没有order by $sort ASC 都出错
晕!!!!

解决了
方法 :
$sql = "SELECT * FROM movement where shop='$shop' order by $sort ASC";

Answer 1

从报错和你的语句上来看，应该是sql执行结果有问题，返回了一个bool值。

var_dump($sql);一下，然后拿到mysql中执行看结果。