Populating Variable from MySql - Beginner Question

[ErocM]

I figured out the MySql statment, tested it and it works fine. What I am needing is to dump the data that I get, two fields, into a table:

Rank (table 1) Username (table 2)

That simple. Here is the code I have so far:

$sql = "SELECT phpbb_ranks.rank_title, phpbb_users.username FROM phpbb_users LEFT OUTER JOIN phpbb_user_group ON phpbb_user_group.user_id = phpbb_users.user_id JOIN phpbb_ranks on phpbb_ranks.rank_id = phpbb_users.user_rank WHERE phpbb_user_group.group_id = $company ";		


if ( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not obtain Company Information', '', __LINE__, __FILE__, $sql);
}

$co_members = array();
while ($row = $db->sql_fetchrow($result) )
{
	$co_members[] = $row['username']; 
       //	echo " test:  $userdata['username'] <br>";
       // 	$username = $group_members['username'];
       //       echo " test:  $result ";
}
            

I cant seem to figure out how to put the information into a variable and drop them into a table....

I keep getting ARRAY or other odd things.

Any help would be greatly appreciated!

Thank,
Eroc

[dnast]

I'm not sure how your db class works, but you might have to fetcharray or fetchassoc as you might not be retrieving an associative array.

Try to echo $row['username'] and $row[0] and see what you get.

You could also print_r($row) to see how it's retrieving rows.

[ErocM]

Originally posted by dnast
I'm not sure how your db class works, but you might have to fetcharray or fetchassoc as you might not be retrieving an associative array.

Try to echo $row['username'] and $row[0] and see what you get.

You could also print_r($row) to see how it's retrieving rows.

When I do the $row[0] it comes back with nothing and when I do the $row['username'] I get this:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\Inetpub\vhosts\9thsf.com\httpdocs\comembers.php on line 67

Eroc

[ErocM]

I hard coded the info in instead of trying to figure out "their" way of doing it... works alot better now and I know what is going on !!!

lol

thx
Eroc

[dnast]

Hehe...best way to do it!