error in the query:SELECT COUNT(*) AS total FROM `hkiraweb_sechand` WHERE `status`=1 AND `beTop`=1 AND `UserCancel` =0 AND `sale`=1 AND CAST(`price` AS INT) BETWEEN '6000000' AND '10000000'
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) BETWEEN '6000000' AND '10000000'' 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/listsechandsale.php(143): mysqlclass->prepare() #2 /var/www/hkira.hk/index.php(21): include_once('/var/www/hkira....') #3 {main}