$username is coming from a required configuration file, it's a global field for when they are logged in. It's pulled from the database, and then put into a session, managed by Apache::Session::MySQL

Yes, all the other WHERE clauses that use it work.

Thx,
Richard.