-
☆ A M B ☆
- 24,524 Posts
I’m trying to be very clever and make the fullest possible use of the MODx DBAPI. I have two queries to generate a list of all users in a given web group:
$userlist = '';
$table1 = $modx->getFullTableName('web_users');
$table2 = $modx->getFullTableName('webgroup_names');
$table3 = $modx->getFullTableName('web_groups');
$result = $modx->db->select("id",$table2,"name = '".$webgroup."'");
$groupid = $modx->db->getValue($result);
$result = $modx->db->select("tbl1.username","$table1 AS tbl1, $table2 AS tbl2, $table3 AS tbl3","tbl3.webgroup=".$groupid." AND tbl1.id = tbl3.webuser", "tbl1.username ASC");
while($users = $modx->db->getRow($result)) {
$userlist .= $users['username'].'<br />';
}
return $userlist;
I know this could be done with a single query. Can anybody with better SQL skills show me how it should be done?
-
☆ A M B ☆
- 24,524 Posts
That did the trick! Thank you!
Jason’s way works also, but I was, as I said, trying to be clever and do it all in one MODx-ish statement!
