Help needed with MySQL query

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
iG9
Forum Commoner
Posts: 38
Joined: Fri Jul 18, 2008 2:11 pm

Help needed with MySQL query

Post 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? =)
tech603
Forum Commoner
Posts: 84
Joined: Thu Mar 19, 2009 12:27 am

Re: Help needed with MySQL query

Post 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 .
iG9
Forum Commoner
Posts: 38
Joined: Fri Jul 18, 2008 2:11 pm

Re: Help needed with MySQL query

Post by iG9 »

Thanks, that did it. I knew that, but I'd been coding so long all the characters were running together. =) Again, thanks.
Post Reply