connect_errno > 0){ die ('Unable to connect to database [' . $db->connect_errno . ']'); } $sqlmaploc = "SELECT treasuredata.treasureid, treasuredata.location FROM treasuredata"; if (!$resultmap = $con->query($sqlmaploc)){ die ('There was an error running the query [' . $con->error . ']'); } echo ''; echo '

'; echo ''; echo 'Select a map location'; while ($rowmap = $resultmap->fetch_array()){ $locname = $rowmap['location']; $locid = $rowmap['treasureid']; echo '' . $locname . ''; } echo '

'; echo '

'; ?>