Deleting users by time

[crouchjay]

I am trying to delete all users from table usersonline after 30 minutes of inactivity.  The query runs, but nothing happens.  How else can I approach this?

Thanks in advance Jay.
[code]$query="SELECT * FROM usersonline WHERE DATE_SUB(NOW(), INTERVAL 30 MINUTE) <= LastTime";[/code]

[fenway]

The following should work, provided ListTime is a datetime field (untested):

[code]SELECT * FROM usersonline WHERE LastTime + INTERVAL 30 MINUTE <= NOW()[/code]