Query Loop within Query Loop .... Need Optimization help

[Xenon]

take a look at that code, that should do what your code di, but just using one query:

PHP Code:

# Categories and subcategories column
$parentcatquery = $DB_site->query("
    SELECT *
    FROM " . TABLE_PREFIX . "articles_category
    WHERE parentcategory=0 ORDER BY categoryorder
");
$categories = $DB_site->query("
    SELECT *
    FROM " . TABLE_PREFIX . "articles_category
    ORDER BY categoryorder
");
$cat_cache = array();
while ($cat = $DB_site->fetch_array($categories))
{
    $cat_cache[$cat['parentcategory']][] = $cat;
}
// parent categories
foreach ($cat_cache[0] AS $parentcatrow)
{
       $parentid = $parentcatrow["articles_categoryid"];
        $catname = $parentcatrow["categoryname"];
        $parentcat = $parentcatrow["parentcategory"];

        eval('$catlistbit .= "' . fetch_template('vbArticles_categorybit') . '";');
        eval('$catlistbit .= "' . fetch_template('vbArticles_categorybit_pre') . '";');

        // now do subcategories
        foreach ($cat_cache[$parentid] AS $subcatrow)
        {
            $subcatid=$subcatrow["articles_categoryid"];
            $subcatname=$subcatrow["categoryname"];
            eval('$catlistbit .= "' . fetch_template('vbArticles_childcatbit') . '";');
        }
    eval('$catlistbit .= "' . fetch_template('vbArticles_categorybit_post') . '";');
}