当彼此循环时分开

我以前发布过代码，但我问了不同的问题，因为我真的不知道发生了什么。

我有几个while循环从数据库中获取数据，以形成最新信息的提要。在你问之前，我会使用mysqli，但现在只是使用mysql，所以我可以对循环进行排序，因为我觉得这样更舒服。

每个sql查询可以但不一定有几行数据，因此需要while循环。我还必须在最后将所有数据组织到一个数组中，以便所有数据都可以按时间戳排序（时间戳还不在sql查询中）。

我遇到的问题是，按照现在的方式，要将所有变量组织到数组中，所有的结束大括号都必须在数组后面，这样才能将每一位数据放入其中。因此，一些变量可能会多次输出，因为每个sql查询中可能有不同数量的行。顺便说一下，括号现在不是这样排列的。

在下面的代码中，while循环的第二批中的每一个的括号都直接在变量后面。这意味着表中只有一行被输出到数组中。

我希望这能解释它。这是我能做的最好的事情。我如何安排while循环，以便第二批查询中的每个查询的所有数据都能输出到数组中？

<?php
    //fetch favourited artist(s)
    $fetchartistFavourite = mysql_query("SELECT * FROM artistfavourites WHERE username = '$username' AND password = '$pass';")or die(mysql_error());
    while ($artistFavourite = mysql_fetch_array($fetchartistFavourite)){
        $favouritedArtist = $artistFavourite['artistname'];
        $favouritedArtistUrl = $artistFavourite['artisturl'];
        //fetch favourite track(s)
        $fetchtrackFavourite = mysql_query ("SELECT * FROM trackfavourites WHERE username = '$username' AND password = '$pass'")or die(mysql_error()); 
        while ($trackFavourite = mysql_fetch_array($fetchtrackFavourite)){
            $favouritedTrack = $trackFavourite['artistname'];
            $favouritedTrackUrl = $trackFavourite['artisturl'];
            //Get news from favourited artist(s)
            //Get updates to bio
            $fetchupdatedBio = mysql_query ("SELECT bio FROM members WHERE artistname = '$favouritedArtist'")or die(mysql_error()); 
            while ($updatedBio = mysql_fetch_array($fetchupdatedBio)){
                $updatedBio = $updatedBio['bio'];
            }
            //Get any new pictures
            $fetchPic = mysql_query ("SELECT picurl FROM pictures WHERE artistname = '$favouritedArtist'")or die(mysql_error()); 
            while ($pic = mysql_fetch_array($fetchPic)){
                $pic = $pic['picurl'];
            }
            //Get any new tracks
            $fetchTracks = mysql_query ("SELECT * FROM tracks WHERE artistname = '$favouritedArtist'")or die(mysql_error()); 
            while ($tracks = mysql_fetch_array($fetchTracks)){
                $trackurl = $tracks['trackurl'];
                $trackname = $tracks['trackname'];
            }
            //Get any new gigs
            $fetchGigs = mysql_query ("SELECT * FROM gigs WHERE artistname = '$favouritedArtist'")or die(mysql_error()); 
            while ($gigs = mysql_fetch_array($fetchGigs)){
                //arrange gig data into format to be echoed
                $gig = $favouritedArtist.' is playing for the gig ' .$gigs['gigname'].' at ' .$gigs['venue'].' on the '.$gigs['day'].'th of '.$gigs['month'].', '.$gigs['year'];
            }
            //Get any new sessions
            $fetchSessions = mysql_query ("SELECT title FROM sessions WHERE artistname = '$favouritedArtist'")or die(mysql_error()); 
            while ($sessions = mysql_fetch_array($fetchSessions)){
                $sessionName = $sessions ['title'];
            }
            //Get new tracks from favourited tracks(s)if the artist has not been favourited
            $fetchnewTrack = mysql_query ("SELECT * FROM tracks WHERE artistname = '$favouritedTrack' AND artistname !='$favouritedArtist'")or die(mysql_error()); 
            while ($newTrack = mysql_fetch_array($fetchnewTrack)){
                $trackname2 = $newTrack['trackname'];
                $trackurl2 = $newTrack['trackname'];
            }
            //asign all variables into an array
            //echo array
        }
    }
?>