[Antivirus]

What i want it to do is this: for each artisttype that is returned, i want to eval the "erc_artistroster_typerow" template and within that it cycles through the "erc_artistroster_rpt" template using the while loop.

Having some difficulty though with the foreach loop below...

here's my code:

PHP Code:

// DEFINE SETTINGS FOR COLUMNS TO SHOW 
$artists_setup = array(
'columns_to_show' => 3,
'fetch_artist' => true
); 
// END Define Settings
 
 
    $qryartists = $db->query_read("
        SELECT erc_artist.*, erc_artisttype.artisttype AS artisttype, MIN(erc_artistimage.artistimageid) AS artistimageid 
        FROM erc_artist
        LEFT JOIN erc_artisttype ON erc_artist.artisttypeid = erc_artisttype.artisttypeid
        LEFT JOIN erc_artistimage ON erc_artist.artistid = erc_artistimage.artistid
        WHERE artistisactive = '1'
        GROUP BY erc_artisttype.displayorder, artisttitle
        ");

        $artistimage = $artist['image'];
        $artistimageid = $artist['artistimageid'];
        $artisttitle = $artist['artisttitle'];
        $artisttype = $artist['artisttype'];
        // Get CURRENT Artist List & fetch template for each item
    foreach (array($artisttype) as $key => $artisttypes
    {
        eval('$artisttypes .= "' . fetch_template("erc_artistroster_typerow") . '";');
        if ($qryartists != '')
            {
                $choicecounter = 1;
                while ($artist = mysql_fetch_array($qryartists)) 
                {
                    eval('$artists .= "' . fetch_template("erc_artistroster_rpt") . '";');
                    $choicecounter++;
                    if (($choicecounter % $artists_setup['columns_to_show']) == 0) 
                    {
                        $newrow = 1;
                    }
                    else 
                    {
                        $newrow = 0;
                    }
                }
            }
    }


    // fetch template 
    eval('print_output("' . fetch_template('erc_artistroster') . '");'); 
} 


I think i need to use a foreach loop, however i'm just getting a blank page now