I'm currently working on building the various user pages. I plan on having the guilds/realms/characters pages display all the user's guilds/realms/characters like when you view all guilds for a realm.
The problem I'm having with this is passing the array of guild_ids, realms, and member_ids to the memberslist preparedata function.

Should I just make a seperate set of functions like memberslist to display the data, or is there a way to pass the array data to memberslist and have it display the info?

So far I can only get it to display a single row. I'll keep playing with it but any help would be great.

You can't really pass it an array of data. You need to build one query that returns all of the data you want in the table. Most likely this means joining roster-standard table with your account table.
I assume you store the account - character relation in a DB table?

Yes, the user_link table stores the user_id, guild_id, member_id, group_id, and server_name. I believe that is all the info I should need to make the query.

Woot! Using a series of left joins and using the memberslist, I successfully queried all characters for a given uid. I never really knew how to do all that LEFT/RIGHT JOIN stuff. But it's pretty handy to know... Thanks for sending me in the right direction Pleeg!

You're welcome.

Nice to hear the memberslist library will be used by other addons as well. Let me know if you run into further trouble.