$array=array('forgot_pass_identity' => $fp_code,'TIMESTAMPDIFF(MINUTE, NOW(), modified)' => '<= 10');
$query = $this->db->get_where($array);//this is the user since the code matches using qb
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' < 10'' at line 4
SELECT * FROM `users` WHERE `forgot_pass_identity` = '33075e45dbde6bb26388c01d0d5c8aed' AND TIMESTAMPDIFF(MINUTE, NOW(), 'modified') ' < 10'
Filename: C:/xampp/htdocs/sub_crud/system/database/DB_driver.php
Line Number: 691
proof that an old dog can learn new tricks