connect_errno > 0){ die ('Unable to connect to database [' . $db->connect_errno . ']'); } if (!$_SESSION['userid']){ echo ''; echo '

Username:
'; echo 'Password:
'; echo '

'; } else { if ($whattoon == "0" or $whattoon == ""){ $sql = "SELECT playerid, charname FROM `playername` WHERE `userid` = '$userid' ORDER BY `charname` ASC"; //need to make userid a variable if (!$result = $con->query($sql)){ die ('There was an error running the query [' . $con->error . ']'); } echo ''; echo '

'; echo ''; echo 'Select a Character'; while ($row = $result->fetch_array()){ $charid = $row['playerid']; $charname = $row['charname']; echo '' . $charname . ''; } echo '

'; echo '

'; } else { $sqltoon = "SELECT charname, profcolor from `playername` WHERE playerid = $whattoon"; if (!$result2 = $con->query($sqltoon)){ die ('There was an error running the query [' . $con->error . ']'); } while ($row2 = $result2->fetch_array()){ $charactername = $row2['charname']; $profcolor = $row2['profcolor']; $_SESSION['profcolor'] = $profcolor; echo ''; echo ''; } echo '

'; $_SESSION['playerid'] = $whattoon; echo '

Select your course of action

'; echo '
• Record loot info
'; echo '
• View Character loot history
'; echo '

'; echo '

'; } echo '

'; } ?>