Lastactivity query

[Boofo]

Can anyone please tell me what is wrong with this line of code?

AND lastactivity>'.$lastposttime[dateline]-(86400*30).'

I am trying to make it so the query will not return the same name over for at least 30 days. If the username has been picked, I don't want his name drawn again for at least another 30 days. Once a month, I guess is what I mean. I think I'm close but I haven't quite got it yet. Anyone have any ideas what I might be missing or doing wrong?

Do I need to use lastvisit instead?

[Xenon]

user brackets around the term :)

($lastposttime[dateline]-(86400*30))

[Boofo]

Like this?

AND lastactivity>($lastposttime[dateline]-(86400*30))

And will that only pick the same username after 30 days and not before?

[Xenon]

nope, just add the brackets to your original query, don't touch the '. ;)

[Boofo]

So you mean like this then.

AND lastactivity>'.($lastposttime[dateline]-(86400*30)).'

[Xenon]

yes :)

[Boofo]

Thank you, sir. ;)