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

[Marco van Herwaarden]

this would give you an array of all the rows in the author table.

You could enumerate them with a

foreach ($authorsname as $key=>$values)

this will give you the index to the array in $key and an array of associated values in $value.

You then could use a $authorsname[$key]['name'] for example, or a $value['name'].

[Marco van Herwaarden]

lol, would really not know, didn't go into the function if this.

[cinq]

This thread is really messy now
But anyways, thanks to everyone for pointing me in the right direction and taking the time to explain stuff

For the author list feature, this is the final code I am employing, just for anyone's reference.

PHP Code:

    $authorquery = $DB_site->query("
        SELECT DISTINCT a.author, u.userid
        FROM " . TABLE_PREFIX . "articles_article a
        LEFT JOIN " . TABLE_PREFIX . "user u
        ON a.author=u.username
        ORDER BY a.author asc
        ");

    $articlequery = $DB_site->query("
        SELECT a.articles_articleid, a.title, a.author
        FROM " . TABLE_PREFIX . "articles_article a
        ORDER BY publishdate desc
        ");

    $article_cache = array();
    while ($article = $DB_site->fetch_array($articlequery))
    {
        $article_cache[$article ['author']][] = $article;
    }

    $authorname_cache = array();
    while ($authorsname = $DB_site->fetch_array($authorquery))
    {
        $authorname_cache[] = $authorsname ;
    }

    foreach ($authorname_cache as $key=>$values)
    {
        $author = $values['author'];
        $userid = $values['userid'];
        $authorartbit = "";
        foreach ($article_cache[$author] AS $article)
        {
            $arttitle=$article["title"];
            $artid=$article["articles_articleid"];
            eval('$authorartbit .= "' . fetch_template('vbArticles_authorartbit') . '";');
        }
        eval('$authorbit .= "' . fetch_template('vbArticles_authorbit') . '";');
    } 


49 -> 7 queries
pheww, finally

[Marco van Herwaarden]

Well done, and if i have time (and still remember ) i will see if i can find anymore optimisations.