CommLink
"; $show = $_POST['SHOW']; $character_id = $_SESSION['cid']; if ($show == 'ALL') { // Display all messages $sql = "SELECT * FROM `message` WHERE `to` = '$character_id'"; } else { // This should not happen... $sql = "SELECT * FROM `message` WHERE `id` = '0'"; } $result = mysqli_query($mysqli, $sql) or die($gameerror . "MR-Q01"); $num = mysqli_num_rows($result); $i = 0; while ($i < $num) { $row = mysqli_fetch_assoc($result); $from_id = $row['from']; $time = $row['time']; $body = $row['body']; $sql = "SELECT `name` FROM `character` WHERE `id` = '$from_id'"; $resultchar = mysqli_query($mysqli, $sql) or die($gameerror . "MR-Q02"); $rowchar = mysqli_fetch_assoc($resultchar); $from_name = $rowchar['name']; echo "
Message from $from_name:
($time)
$body
"; $i++; } echo ""; } else { echo $gameseserr; } // Not logged in mysqli_close($mysqli); echo $footer; ?>