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.