Hopefully a very easy question for those with experience...

sonfohud

I have some information I'm trying to display from a database and I don't really know how to go abot doing it(i'm a n00b). This is what I have so far:

$query="SELECT user_id FROM phpbb_user_group WHERE 1 AND group_id= '232' ORDER BY user_id ASC";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<center>Database Output</center> ";

$i=0;
while ($i < $num) {

$user_id=mysql_result($result,$i,"user_id");

echo "$user_id ";

++$i;
}

?>

This just displays the user_id, which is a number. I'm trying to display the username from the phpbb_users table, but only want it to print the usernames of people who have group_id 232 from the phpbb_user_group table. I hope this makes sense...it can't be that hard. I just can't figure it out.

drew010

$query="SELECT user_id, group_id FROM phpbb_user_group WHERE group_id= '232' ORDER BY user_id ASC";

$result=mysql_query($query);

echo "<center>Database Output</center> \n";

while($data = mysql_fetch_object($result)) {
echo $data->user_id . " \n";
}

Hope that works, if not post back.

sonfohud

Hey thanks...it doesnt seem to be working though....

sonfohud

Ok....this is the whole code I'm using:

<?
$username="username";
$password="pass";
$database="database";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT user_id FROM phpbb_user_group WHERE 1 AND group_id = 232 ORDER BY user_id ASC";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {

while($data = mysql_fetch_object($result)) {
echo $data->user_id . " \n";
}

++$i;
}

?>

This is the page its on:

www.imperialelites.net/test2.php

It's just displaying the user_id numbers. I want it to display the usernames from the user_id numbers that were just queried.

sonfohud

<?
$username="user";
$password="pass";
$database="db";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM phpbb_user_group, phpbb_users WHERE (phpbb_user_group.group_id='232') ORDER BY username ASC";
$result=mysql_query($query);

mysql_close();

while($data = mysql_fetch_object($result)) {

echo $data->username . " ";

}

OK...this is what I have now and I get the list of user names and
it lists all the usernames in field....not just the ones in group_id 232. It also lists the names 20 times each.

snaack

it's quite easy, you should join the tables..

SELECT userName 
	FROM phpbb_user_group g, phpbb_users u
	WHERE g.group_id=232
	AND g.user_group_id = u.user_group_id
	ORDER BY u.userName ASC

Something like that.. I don't have the DB-structure so fieldnames could differ 😉