Question

sql文在MySql-Front里执行正常，但是放在php里执行就不行了，求真相，在线等！

SELECT IFNULL(whpj.xianchaomaichujia_bank,'0') AS cm, IFNULL(jishu.xianzaizuidazhi,'0') AS max FROM jishu LEFT JOIN whpj ON jishu.bankid=whpj.bank_id and whpj.bizhong=jishu.bizhongid and whpj.xianzaizuidazhi = jishu.xianzaizuidazhi

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in admin.php.

Answer 1

把执行这句sql那加个输出，看看到底报什么错，如：
sql = "SELECT ...........";
$result = mysql_query( $sql ) or die( mysql_error );

追问

near '\'0\') AS cm, IFNULL(jishu.xianzaizuidazhi,\'0\') AS max FROM jishu LEFT' at line 2
谢谢解决了，double型的数据不该用'0',应该用0。