PHP Mysql problem

Ok guys, I have a really big problem and I need some help. My website:
www.magnetgames.org I?m using a php mysql database. I?v set up a PHPBB forum.
Now I want on my main page, to show ALL USERS THAT ARE PART OF A USER GROUP.
That?s what I want. Now this is how the information is stored in the databases:
http://www.magnetgames.org/Problem.gif As you can see here, the username
from user_id 2 is Ajantis-X- So I want to show Ajantis-X- and all other users
that are part of the usergroup 4! How to do this? I know the basic php: SELECT
blablabla FROM blablabla WHERE blablabla = blablabla But I have no idea how to
do this, with the information stored in 2 different tables! Please help!

I realy need an awnser, please. who knows php and can help me?

SOMEONE??!!!??

please!

To get all the users who belong to a certain group use something like this:
SELECT * FROM group,user WHERE group.group_id = x AND user.user_id = group.user_id.

i tryed this:
'SELECT * FROM phpbb_users WHERE phpbb_user_groups.group_id = 4 AND phpbb_users.user_id = phpbb_user_groups.user_id. '
but that dosnt work!

You need a join I think to connect the two tables together - there are
extensions that help with this - look on the dream weaver site to find one.



On 11/20/04 12:49 PM, in article cno03h$4cl$1 (AT) forums (DOT) macromedia.com,
"rG]Courage-D-" <webforumsuser (AT) macromedia (DOT) com> wrote:

Ok guys, I have a really big problem and I need some help. My website:
www.magnetgames.org I?m using a php mysql database. I?v set up a PHPBB forum.
Now I want on my main page, to show ALL USERS THAT ARE PART OF A USER GROUP.
That?s what I want. Now this is how the information is stored in the
databases:
http://www.magnetgames.org/Problem.gif As you can see here, the username
from user_id 2 is Ajantis-X- So I want to show Ajantis-X- and all other users
that are part of the usergroup 4! How to do this? I know the basic php:
SELECT
blablabla FROM blablabla WHERE blablabla = blablabla But I have no idea how
to
do this, with the information stored in 2 different tables! Please help!

I just don't understand
What exactly don't you understand? The command I posted will return all the
fields of all the users in the user's table that belong to the group x (or four
in your case).

this are the tables: http://www.magnetgames.org/Problem.gif
Yes, I saw them before I posted my previous answer and ran a test with a table
I have that has a similar structure and it worked as was supposed to.

maybe it might be a little bit mutch i ask, but can you create the code like i
can copy and past it? so when you first gave me this: SELECT * FROM group,user
WHERE group.group_id = x AND user.user_id = group.user_id. can you change it
so that i can use it without any changes (for example, change the X into a 4)
here is what i have now: (dosnt work)

mysql_select_db($database_localhost, $localhost);
$query_GuildMembers = "SELECT * FROM group,user WHERE group.group_id = 4 AND
user.user_id = group.user_id.";
$GuildMembers = mysql_query($query_GuildMembers, $localhost) or
die(mysql_error());
$row_GuildMembers = mysql_fetch_assoc($GuildMembers);
$totalRows_GuildMembers = mysql_num_rows($GuildMembers);

Remove the dot at the end of the following line:
$query_GuildMembers = "SELECT * FROM group,user WHERE group.group_id = 4 AND user.user_id = group.user_id";

You will have to change the names of the tables. I used group and user but I don't know if those are the correct names.