I want to have a seperate login page for visitors to my site and for the admin.
I have used seperate tables for the two entities but it seems as though I am
restricted to just one login. The idea is that members of the site can see the
email, first and last name of other members, but the full details are only
available to the admin for the purposes of editing those details. Is the only
workaround to build a seperate admin site?

For that purpose I would not see the need to query 2 separate user databases if
the only difference is the extent of the content being queried. All you need
is a field distinguishing the user types so when the query is executed you get
what you expect.

And just to answer your question about 2 separate logins, there is no reason
why you could not have a separate login for a separate application or anything
else for that reason. It all depends on how you set up the databases or how
the application is set up.

Snake is right. Use one table and filter.

The number of concurrent users will be determined by your internet host.

Glenn

Ok thanks for that