if (strlen($rowName) > 0) { $return['environ'][] = $rowName; } } $stmt->close(); $stmt = $mysqli->prepare("SELECT CM.name FROM mm_creatures CB\n\t\t\t\t\t\t\t\t\t\t INNER JOIN mm_minions M ON CB.id = M.boss_id\n\t\t\t\t\t\t\t\t\t\t INNER JOIN mm_creatures CM ON M.minion_id = CM.id\n\t\t\t\t\t\t\t\t\t\t WHERE CB.name = ?"); $stmt->bind_param("s", $name); $stmt->execute(); $stmt->bind_result($rowName); while ($stmt->fetch()) { if (strlen($rowName) > 0) { $return['minion'][] = "<a href='MonsterDisplay.html?name=" . $rowName . "'>" . $rowName . "</a>"; } } $stmt->close(); $stmt = $mysqli->prepare("\tSELECT CB.name\n\t\t\t\t\t\t\t\t\t\tFROM mm_creatures CB\n\t\t\t\t\t\t\t\t\t\tINNER JOIN mm_minions M ON CB.id = M.boss_id\n\t\t\t\t\t\t\t\t\t\tWHERE M.minion_id = (SELECT id FROM mm_creatures WHERE name = ?)"); $stmt->bind_param("s", $name); $stmt->execute(); $stmt->bind_result($rowName); while ($stmt->fetch()) { if (strlen($rowName) > 0) { $return['bosses'][] = "<a href='MonsterDisplay.html?name=" . $rowName . "'>" . $rowName . "</a>"; } } $stmt->close(); return json_encode($return); } } $ajaxRequest = new ajaxRequest(); echo $ajaxRequest->requestLists();