區 域:
不限更 多:
error in the query:SELECT * FROM `hkiraweb_sechand` WHERE `sale`=0 AND `status`=1 AND `beTop`=0 AND `UserCancel`=0 ORDER BY CAST(`price` AS INT) DESC LIMIT 5 OFFSET 0
PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 'INT) DESC LIMIT 5 OFFSET 0' at line 1 in /var/www/hkira.hk/includes/mysql.class.php:35 Stack trace: #0 /var/www/hkira.hk/includes/mysql.class.php(35): PDO->prepare() #1 /var/www/hkira.hk/project/hkiraweb/html/listsechandrent.php(866): mysqlclass->prepare() #2 /var/www/hkira.hk/index.php(21): include_once('/var/www/hkira....') #3 {main}
PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 'INT) DESC LIMIT 5 OFFSET 0' at line 1 in /var/www/hkira.hk/includes/mysql.class.php:35 Stack trace: #0 /var/www/hkira.hk/includes/mysql.class.php(35): PDO->prepare() #1 /var/www/hkira.hk/project/hkiraweb/html/listsechandrent.php(866): mysqlclass->prepare() #2 /var/www/hkira.hk/index.php(21): include_once('/var/www/hkira....') #3 {main}