I was wondering if someone with more skills than myself
would be willing
to throw together either a select statement or a quick php
page that
would return all the maia users and their linked email
addresses. I have
quite a few clients that wanted special email accounts
linked to
different users (info sales etc) but now I can't
remember who is
linked to what!
What I'd like for readability is the maia username on the
left, and then
all the linked addresses on the right. So far I'm doing:
select maia_users.user_name, users.email
from maia_users, users
where maia_users.id = users.maia_user_id
order by maia_users.user_name;
This gets me the basic info I want, but I'd like to format
it for
readability by only including the Maia username once (as
stated above)
and also removing all domain-only entries (domain.com).
Thanks for any help!
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
|