[paul41598]

lol, ya I always do it seems

So if I'm trying to pull all email address who are IN those $usergroupids

$usergroups = $vbulletin->db->query_read("
    SELECT usergroup.usergroupid, usergroup.title, user.email
    FROM " . TABLE_PREFIX . "usergroup AS usergroup, user AS user
    WHERE usergroup.usergroupid IN ($usergroupids)

");

I tried the LEFT join on the user table, no good. Can you point me in the right direction of what I'm missing here?

UPDATE: ( 9:33pm)
Ok I've been working on this. Instead of the query going in the form complete, I'm putting it in there newthread post complete: Here is my updated code. It wont work though.

$vbulletin->input->clean_array_gpc('p', array('groupID' => TYPE_ARRAY));

foreach ($vbulletin->GPC['groupID'] AS $id)
{
$ids = $id;
}

$usergroups2 = $vbulletin->db->query_read("
    SELECT email
    FROM " . TABLE_PREFIX . "user
    WHERE usergroupid IN ($ids)
");

while ($usergroups3 = $vbulletin->db->fetch_array($usergroups2))
{
//send to my email to test if subject line is parsing variables
vbmail("my_email_was_here.net", $usergroups3['email'], $message);
}