Rewrite this line please ?

[Marc]

I'm a complete newbie and still learning to work with php.
When i wrote this line it was throwing me errors no matter what i did.
Can someone lok into this and make it work please??
Do i use a " or ' or ) to make it work.
Thanks

      $r_users = q("SELECT * FROM dt_profile WHERE lastlogin (NOW()) - lastlogin(timestampkolom) > 1);

while($f_user = f($r_users))
    { 
    q("DELETE FROM dt_members, dt_profile WHERE id='$f_user[id]'"); 
}  

[jpmoriarty]

a couple of points:

always calculate any values you need in a query before putting them into your sql:

ie
$lastlogin = mktime() - 1500; (etc or whatever you want)

then:
$sql = "SELECT * FROM dt_profile WHERE lastlogin > $lastlogin"
etc - your query was hard to understand due to functions and a lack or comparisons (ie = or > signs)

similarly, if you need to access an array, then break out of the echo:

"DELETE FROM dt_members, dt_profile WHERE id='".$f_user[id]."'";

That should help you some

[matto]

and in addition to that:

$r_users = q("SELECT * FROM dt_profile WHERE lastlogin (NOW()) - lastlogin(timestampkolom) > 1);

you forgot the closing quote " at the end of the select statement.