Code: Select all
$sql = '
SELECT
field7, userid
FROM
website_forum.rbf_userfield
';
$query = mysql_query($sql) or die(mysql_error());
$countries = array();
while ($info = mysql_fetch_assoc($query))
{
$sql = '
SELECT
count(id) AS thecount
FROM
rb_usermap
WHERE
fk_vb_user_id = "'.$info['userid'].'"
AND
status = "1"
';
$query2 = mysql_query($sql) or die(mysql_error());
$info2 = mysql_fetch_assoc($query2);
if (!array_key_exists($info['field7'], $countries))
{
$countries[$info['field7']] = 0;
}
$countries[$info['field7']] += $info2['thecount'];
}
dump($countries);Code: Select all
SELECT
count(um.id)
FROM
website_site.rb_usermap AS um
LEFT JOIN
website_forum.rbf_userfield AS uf
ON
um.fk_vb_user_id = uf.userid
WHERE
um.STATUS = 1
AND
uf.field7 = 'United States'