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/showt...61#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 [DATE]1225872785[/DATE] at [TIME]1225872785[/TIME] ---------------

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:

PHP Code:

$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.