You would want to put the code in sub html_record, as the record is being displayed.

Depending on how many items are in your log file, it could take quite a long time to go through all of the records.

You might think about writing the necessary fields to the session file for the user. That way you wouldn't have to search through other userids.

What did we end up with when you were working on preventing users from logging in more than once per day?

JPD
http://www.jpdeni.com/dbman/