Code: Select all
SELECT id,name,email FROM intranet.usersCode: Select all
SELECT userid,groupid FROM intranet.users_associatedgroups WHERE groupid={$_POST['groupid']}userid is a reference from intranet.users ID
Help please?
Moderator: General Moderators
Code: Select all
SELECT id,name,email FROM intranet.usersCode: Select all
SELECT userid,groupid FROM intranet.users_associatedgroups WHERE groupid={$_POST['groupid']}Code: Select all
SELECT id,name,email FROM intranet.users
WHERE id in (SELECT userid FROM intranet.users_associatedgroups WHERE groupid={$_POST['groupid']})
lol thank you, having a really bad day today. planning an engagement for the weekend, work is packed, and the kid is sick. thank you againRatzzak wrote:Try this...
Code: Select all
SELECT id,name,email FROM intranet.users WHERE id in (SELECT userid FROM intranet.users_associatedgroups WHERE groupid={$_POST['groupid']})