Date calculation is not deleting members

[Marc]

Hi

I'm working on a script so that users sign up to my website they have to validate there e-mailaddress before they can go to the next step in there registration.
I setup a prepared_members table in Mysql and when they click the e-maillink they get auto-erased out of the prepared_members table.
All works well, except for members that are using e-mailaddresses who are not valid.
The e-mailaddresses are kept in the prepared_members forever...
To remove them out of there after 2 days i am using a scheduler file that's called when my index opens.
The file does more than only clearing tables and works, but the problem is that i cannot get it to work to erase those prepared members.
Here is the code

$r_users = q("SELECT * FROM dt_prepared_members WHERE idate-".(strtotime(date("d M Y H:i:s")))." > 172800"); 
while($f_user = f($r_users)) 
{ 
q("DELETE FROM dt_prepared_members WHERE id='$f_user[id]'"); 
}

Thanks

[AlGale]

Hi,

I might be being really stupid here, I was just browsing through some of the posts. But shouldn`t your query string be:

WHERE idate=

not

WHERE idate-

???