Ed - php/vb mysql question

[Me2Be]

Ed, I asked you this before, but of course I didn't keep it.

Using MySql, how do I find out which users have marked themselves invisible - and separately, which users have marked themselves for "no" admin contact

Thanks!

[Freddie Bingham]

Users who don't want you to email them:

select * from user where adminemail = 0

Users who are invisible:

select * from user where invisible = 1