BUG:
Error Number: 1064
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 ''4'' at line 1
SELECT a.*,b.user_nickname, b.user_head_url from qk_user_album a, qk_user b where a.album_user_id = b.user_id ORDER BY a.album_create_date desc LIMIT 0, '4';
Filename: D:\DEV_PHP\WAMP\www\qk\system\database\DB_driver.php
Line Number: 330
问题解决:
这里用到的是limit语法,两个参数应该都是数字,不应该出现字符串
查明的原因是PHP传递参数的时候,第二参数没有做转换,加一个intval函数,字符串转数字即可