Page 1 of 1

Help needed with MySQL query

Posted: Thu Apr 09, 2009 5:28 pm
by iG9
Having trouble crafting the appropriate query. I'm trying to list all my site's users that are members of a certain group. Here are the relevant tables:

Code: Select all

member_info
+------------+-----------+----------+
| first_name | last_name | memberID |
+------------+-----------+----------+
| Joshua     | Howard    |        1 | 
| Dayv       | Rolfe     |        2 | 
| kerry      | test      |        3 | 
+------------+-----------+----------+
 
groups
+---------+-----------+--------------+------------------------------------+----------+
| groupID | moderator | name         | description                        | category |
+---------+-----------+--------------+------------------------------------+----------+
|      20 |         1 | Dayv's Group | A group for Dayv, and no one else. | People   | 
|      19 |         1 | Dog People   | Snouts, Kibble, Corneas!           | People   | 
+---------+-----------+--------------+------------------------------------+----------+
 
 group_members
+-----------------+---------+----------+---------------------+---------------------+
| group_member_ID | groupID | memberID | date_joined         | date_left           |
+-----------------+---------+----------+---------------------+---------------------+
|               9 |      20 |        2 | 2009-04-09 16:39:01 | 0000-00-00 00:00:00 | 
|               8 |      19 |        1 | 2009-04-09 15:33:06 | 0000-00-00 00:00:00 | 
+-----------------+---------+----------+---------------------+---------------------+
 
Query I think should work mut which returns an empty set:

Code: Select all

 
select first_name, last_name  from member_info, group_members where member_info.memberID = group_members.memberID & group_members.groupID = 20;
 
Any takers? =)

Re: Help needed with MySQL query

Posted: Thu Apr 09, 2009 7:04 pm
by tech603

Code: Select all

select first_name, last_name  from member_info, group_members where member_info.memberID = group_members.memberID & group_members.groupID = 20;
If your going to use the

Code: Select all

&
you need 2 "

Code: Select all

&&
" or you could just use " AND " they both work.
select first_name, last_name from member_info, group_members where member_info.memberID = group_members.memberID && group_members.groupID = 20
Hope that helps .

Re: Help needed with MySQL query

Posted: Thu Apr 09, 2009 9:54 pm
by iG9
Thanks, that did it. I knew that, but I'd been coding so long all the characters were running together. =) Again, thanks.