function showAllForUser($id) { $db = DB::GetConn(); $getQuery = "SELECT `ID` FROM `Hero` WHERE `OwnerID` = {$id};"; $res = $db->query($getQuery); //execute query echo "<table style='width: 100%;'>\n\t\t\t<tr>\n\t\t\t<td>Name</td>\n\t\t\t<!--<td>OwnerID</td>\n\t\t\t<td>PartyID</td>-->\n\t\t\t<td>Race</td>\n\t\t\t<td>Class</td>\n\t\t\t<td>HP</td>\n\t\t\t<td>Level</td>\n\t\t\t<td>XP</td>\n\t\t\t<td>Str</td>\n\t\t\t<td>Dex</td>\n\t\t\t<td>Con</td>\n\t\t\t<td>Int</td>\n\t\t\t<td>Wis</td>\n\t\t\t<td>Cha</td>\n\t\t\t<td>Weapon</td>\n\t\t\t<td>Level UP</td>\n\t\t\t<td>Revive</td>\n\t\t\t<td>Fight</td>\n\t\t\t</tr>"; $totalHeros = 0; while ($obj = $res->fetchObject()) { $Hero = new Hero(); $this->outputInTable($Hero->loadHero($obj->ID)); $totalHeros++; } echo "Showing " . $totalHeros . " results.<br />"; echo "</table>"; return $totalHeros; }