Zend Db Table delete() not working properly

Question

I have the following code:

$time = 60 * 60 * 24 * 3;

$usersTable = new Application_Model_Db_Users();

$where = 'active = false AND registration_time < ' . time() - $time;
$usersTable->delete($where);

But when it is run it deletes all the rows in the table, where as when I run

DELETE FROM users
WHERE active = false
AND registration_time < 1290500000

Only the ones that match the criteria are deleted. What is the problem?

can you confirm Zend_Db_Table evaluates to the same query as the query you show? Add a Zend_Db_Profiler to find out. Also, wouldn't it make more sense to calculate the interval in SQL instead of PHP. — Gordon
– Gordon, Commented Nov 25, 2010 at 14:43

Jerome Coloma · Accepted Answer · 2010-11-25 15:01:33Z

3

You just need to wrap it with parenthesis, so that time() - $time evaluates properly.

$where = 'active = false AND registration_time < ' . (time() - $time);

answered Nov 25, 2010 at 15:01

Jerome Coloma

711 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Zend Db Table delete() not working properly

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related