What is wrong with this?

[Gary King]

Originally Posted by Scrub

Instead of making another thread, I'll post in this one. . Anyways, I am stuck yet again and on something that I thought would've been easy to do. :x.

Anyways, I am trying to achive something like member.php does, but no luck in making it work. I've scanned countless files trying almsot everything. LOL. But I need to show a username according to the userid, hence like the member.php file. Thanks in advanced.

$userinfo = fetch_userinfo($userid);

Then $userinfo is an array that has all the user info such as username, $userinfo['username'], etc.

[Scrub]

You are the king! Thanks again!

[Scrub]

Hello again!

I am currently trying to pull users from a specific usergroup out of the database. How would I go about doing that? This is the query I have. It only pulls one user out of the database.

PHP Code:

$user = $DB_site->query_first("SELECT username FROM " . TABLE_PREFIX . " user WHERE usergroupid = 10"); 


[Gary King]

Using the query_first only gets the first result; use query instead, but then you need to use $DB_site->fetch_array($user); in a while statement.

[Scrub]

Hey,
I appreciate all the help, Gary W. But I am comfused on the while statement. I can't seem to figure out how you make one pretty much. I've looked through the PHP Manual, vBulletin Manual, searched several PHP sites and I am still baffled. I understand a little part I belive.

PHP Code:

if ($_REQUEST['do'] == 'this_thing')
        {
                $users = $DB_site->query("
                            SELECT * 
                            FROM " . TABLE_PREFIX . " user AS user
                            WHERE user.usergroupid = 10
                            ORDER BY user.userid DESC
                            ");

                while ($user = $DB_site->fetch_array($users))
                    {    
                        $username = fetch_musername($user);
                        eval('$main_template_bits = "' . fetch_template('main_template_bits') . '";');
                    }

            eval('print_output("' . fetch_template('main_template') . '");');
        } 


Amd I on the right track? LOL. And I'd very much appriciate if you can make a working sample of a while statement that is in KISS format. . Again, I'd like to thank you and everyone else for all the help.

[Gary King]

Try something like

PHP Code:

if ($_REQUEST['do'] == 'this_thing') 
{ 
    $users = $DB_site->query(" 
        SELECT * 
        FROM " . TABLE_PREFIX . " user AS user 
        WHERE user.usergroupid = 10 
        ORDER BY user.userid DESC 
    "); 
    
    while ($user = $DB_site->fetch_array($users)) 
    {     
        $username = fetch_musername($user); 
        eval('$main_template_bits .= "' . fetch_template('main_template_bits') . '";'); 
    } 
    
    eval('print_output("' . fetch_template('main_template') . '");'); 
} 


Then the main_template_bits would contain a <tr> most likely, or <br /> at the end.

[Scrub]

Thanks man! Though I still don't see where I went wrong at though. Could've it have actually been the template where I forgot the <br /> tag?

Edit: The <br /> kind of messed up the layout. So I removed it and it still works. .

Edit again: NEvermind. I missed a . in the eval part in the while query!

But thank you so much!