Extract mailing list by language selection

[Cibulo]

Hello, I ask here for help as I have posted a request on vbulletin.com and they suggested me to show up here for my request.

I have a forum where people choose their favourite language: english and spanish.
I need to extract two mailing list from my forum, depending on the language they have selected. So then I will be able to use poMMo in order to send separate mailing lists depending on the preferred language.

For further info, please give a look at the original thread http://www.vbulletin.com/forum/showthread.php?p=1647461#post1647461

I am a total newbie as far as php and programming is concerned, so I count on your help and kindness.

Thank you so much,

--------------- Added 1225872785 at 1225872785 ---------------

anyone can help me on this? It would be really useful for me! :(

I'd like to send two separate November newsletter, one in english and the other one in spanish...

[Cibulo]

come on guys, please! ;)

[Gio~Logist]

A query like this is what you'd want.

select userid, username, email from user WHERE languageid == 'x'

So in a vb page it will be something like:
$vbulletin->db->query_read("SELECT userid, username, email
FROM " . TABLE_PREFIX . "user
WHERE languageid == 'x'
");

Replace x with the languageid for the language you're trying to pull info based on.