Clan Roster

[SmEdD]

Ok I am building a roser page for my clan. All the data is imputed just like user are but it can only be done in the admin panel.

Now I am working on the public side where it shows the roster to the public.

I can only get one name to come up. How do I get them all to list. And my template is set up with a bits part so it isn't that.

This is the php code that is where the data gets called. Is it anything here or with the template?

PHP Code:

if ($_REQUEST['do'] == 'getall')
{
        $clanrosters = $DB_site->query("
            SELECT * 
            FROM " . TABLE_PREFIX . "clanroster
            ORDER BY displayorder");
    while ($clanroster = $DB_site->fetch_array($clanrosters))
    {
        eval('$rosterbits = "' . fetch_template('rosterbits') . '";');
    }
}