Welcome Guest, Not a member yet? Register   Sign In
how to clear a field in database in x mins?
#6

(This post was last modified: 07-13-2018, 11:50 AM by richb201.)

$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
Reply


Messages In This Thread
RE: how to clear a field in database in x mins? - by richb201 - 07-13-2018, 11:23 AM



Theme © iAndrew 2016 - Forum software by © MyBB