Jump to content

Hybrid-Halo

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Hybrid-Halo's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. At 5am I found the solution. The solution (as always) was simpler than I had expected. I spent a few hours reading up on SQL SELECT's and found that I just needed to be more specific with the query so as to avoid anonymous data problems impeding properly filtering the results. For future reference, here's my new query. [quote] SELECT `phpbb_user_group`.`group_id`, `phpbb_user_group`.`user_id`, `phpbb_users`.`user_id`, `phpbb_users`.`username` FROM `phpbb_user_group` , `phpbb_users` WHERE '107' =  `phpbb_user_group`.`group_id` AND `phpbb_users`.`user_id` =  `phpbb_user_group`.`user_id` ORDER BY `phpbb_users`.`user_id` ASC [/quote] Night guys.
  2. After scouring the internet, I think that this thread holds the foundations for a solution I seek hence my bumping it. My problem is simple, I'm calling data from a phpbb install into my design. The problem arises when I'm trying to display usernames which belong only to one certain group_id. Querying both phpbb_users and phpbb_user_group WHERE group_id = 107 seems to bring up many duplicate results. In search of a solution I created two recordsets. 1 : queries phpbb_user_group WHERE group_id = 107. This provides the correct amount of results alongside the user_id's. 2 : queries phpbb_users for user_id and username Now what I want to do is display data from phpbb_users where user_id's are the same as the 15 or so displayed on the first recordset. For the record : I've had no success implementing the array function above, though that could be because I am an absolute php novice and just don't know how to go about using it. The same excuse applies as to why I'm either missing the obvious, or making no sense. If anyone's able to help or requires more information just ask. Thanks. -Matt.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.