prepare("SELECT * FROM gwtitles ORDER BY titlename"); $stmtview->execute(); $result = $stmtview->get_result(); while ($row = $result->fetch_assoc()) { $tid = $row['titlenameid']; $tname = $row['titlename']; $tnr = $row['titlemaxrank']; echo '' . $tname . ' (' . $tnr . ')'; } $stmtview->close(); } ?>