Indie-Resource.com

Code: Select all

<?php
include 'connect.php';
session_start();

//check to make sure player is logged in and store session variable in local variable if they are
if (!$_SESSION['playername']) {
     echo "You are not logged in. Please go back and log in.";
     echo "<a href='login.php'>Log in</a>";
} else { 
     $player = $_SESSION['playername'];
}
?>
<table border="2" cellpadding="3" cellspacing="0">
<tr>
     <th>From</th>
     <th>Subject</th>
     <th>Message</th>
</tr>

<?php
//pull messages from the database
if ($result = mysqli_query($db, "SELECT * FROM messages WHERE to_user='$player'") {
     //fetch each message from the associative array one by one
     while ($row = mysqli_fetch_row($result)) {
           //find out if the message is read, and bold it if not
           if (!$row[5]) {
                echo "<b>";
           }
           //turn PHP off to create the rest of the table
           ?>
           <tr>
                <td><?php echo($row[1]); ?></td>
                <td><?php echo($row[3]); ?></td>
                <td><?php echo($row[4]); ?></td>
            </tr>
            <?php //turn PHP back on to unbold if needed and finish up script
            if (!$row[5]) {
                echo "</bold>";
            }
           //turn off PHP to end the table
           ?>
           </table>
     <?php
     //marking all messages as read
      if (!($updtd = mysqli_query($db, "UPDATE messages SET message_read = 'true' WHERE to_user='$player'"))) {
             echo "Unable to set messages as read.";
      }

     }
} else {
     echo "You have no messages.";
}

?>

      

Code: Select all

if ($result = mysqli_query($db, "SELECT * FROM messages WHERE to_user='$player'") {

Code: Select all

echo "<small>";
      echo "<center>";
      echo "<table border='0' width='70%' cellspacing='20'>";
     echo "<tr><td width='25%' valign='top'>";
      echo "</td>";
      echo"<td valign='top' width='75%'>";
      $messageinfo="SELECT * FROM messages WHERE to_user='$player'";
      $messageinfo2=mysql_query($messageinfo) or die("could not select messages.");
      echo"<table border='1' bordercolor='black' >";
     echo "<tr><td>From</td><td>Subject</td><td>Message</td><td></td></tr>";
      while($messageinfo3=mysql_fetch_array($messageinfo2))
      {
if($messageinfo3['message_read'] == 1)
{
$messageread = "New!";
}
else
{
$messageread = "";
}
      echo "<tr><td>$messageinfo3[from_user]</td><td>$messageinfo3[message_title]</td><td>$messageinfo3[message_contents]</td><td>$messageread</td></tr>";

      }

      print "</table>";
      print "</td></tr></table>";
      print "</center>";
      echo "</small>";