Anyone care to enlighten me as to why 188 queries are used on a page?

[Arianna]

For myadopts.php I came up with the following solution:

PHP Code:

if($act == ""){
    // No action specified, we just show all the adoptables with a manage link
    $title = "Your Adoptables";
    $page = $lang_adoptmanagement;
    // We need to get all of the user's adoptables from the database and display them...
    $query = "SELECT * FROM adopts_owned_adoptables, adopts_adoptables, adopts_levels WHERE adopts_owned_adoptables.owner = '{$loggedinname}' AND adopts_adoptables.type = adopts_owned_adoptables.type AND adopts_levels.thisislevel = adopts_owned_adoptables.currentlevel AND adopts_levels.adoptiename = adopts_adoptables.type";
    $result = mysql_query($query);
    $query_list[] = $query; 
    $query_count++;
    $num = mysql_numrows($result);
    $page .= "<table>";
    //Loop out code
    $i=0;
    while ($i < $num) {
        $aid=@mysql_result($result,$i,"adopts_owned_adoptables.aid");
        $currentlevel=@mysql_result($result,$i,"adopts_owned_adoptables.currentlevel");
        $gender=@mysql_result($result,$i,"adopts_owned_adoptables.gender");
        $type=@mysql_result($result,$i,"adopts_owned_adoptables.type");
        $name=@mysql_result($result,$i,"adopts_owned_adoptables.name");
        $eggimage=@mysql_result($result,$i,"adopts_adoptables.eggimage");
        $usealternates=@mysql_result($result,$i,"adopts_owned_adoptables.usealternates");
        $totalclicks=@mysql_result($result,$i,"adopts_owned_adoptables.totalclicks");
        $primaryimage=@mysql_result($result,$i,"adopts_levels.primaryimage");
        $alternateimage=@mysql_result($result,$i,"adopts_levels.alternateimage");
        if ($usealternates=='yes') { $image = $alternateimage; }
        else { $image = $primaryimage; }
        if ($currentlevel==0) { $image = $eggimage; }
        if ($image=='') { $image = $primaryimage; }
        $page .="<tr><td style='width: 90px;'>".$name."</td><td style='width: 80px'><a href='myadopts.php?act=manage&id=".$aid."'><img src='".$image."'></a></td><td style='width: 55px;'><img src='picuploads/".$gender.".png'></td><td style='width: 80px'>".$type."</td><td style='width:50px'>".$totalclicks."</td></tr>";
        $i++;
    }
    $page .= "</table>";
} 


It takes 1 query, as opposed to 84.
As for adopt.php, I've reduced it to 2 queries a pet (7 a page for 3 pets), but I'm working on getting it into one join query.