By jeepfreak on

I currently have this code, but I was hoping to combine it into 1 query... I just can't figure out how to do it. Anybody know?

$result1 = db_query("SELECT COUNT(*) from {group_members} WHERE uid = '%d' && gid = '%d'", $user->uid, $node->gid);
$result2 = db_query("SELECT COUNT(*) from {group_requests} WHERE uid = '%d' && gid = '%d'", $user->uid, $node->gid);
if (db_result($result1) == '0' && db_result($result2) == '0') {

Thanks,
Billy

Comments

gwerker’s picture

gwerker commented

You could use something like this:

("SELECT
(SELECT COUNT(*) as 'gm_count' from {group_members} WHERE uid = '%d' && gid = '%d'),
(SELECT COUNT(*) as 'gr_count' from {group_requests} WHERE uid = '%d' && gid = '%d')
", $user->uid, $node->gid, $user->uid, $node->gid)

Personally, I prefer what you already have.

jeepfreak’s picture

jeepfreak commented

I appreciate your response. I'm still learning about optimizing my queries.
Billy