Location: PHPKode > projects > EasyFest > new/user_inbox.php
<?php
include_once("include/db_connection.php");
	header("Expires: Thu, 17 May 2001 10:17:17 GMT");    // Date in the past
	header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
	header ("Cache-Control: no-cache, must-revalidate");  // HTTP/1.1
	header ("Pragma: no-cache");                          // HTTP/1.0              
	session_start();
		if($_SESSION["loggedIn"] == FALSE){
		header("Location:user_login.php");
		exit;
			
	}include_once("config.php");
		$UserName=$_SESSION['UserName'];

	include('header1.php');
	$query1=mysql_fetch_array(mysql_query("select UserName FROM users WHERE Type='1' AND  UserName='$UserName'" ));
if($UserName==$query1['UserName'] ){
	 echo $UserName;
	 include('left_user.php');}
	 else{
	
	 include('left_coord.php');
	}?>
    
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Premium Series by Free CSS Templates</title>
<meta name="keywords" content="" />
<meta name="Premium Series" content="" />
<link href="default.css" rel="stylesheet" type="text/css" media="screen" />

<script language="JavaScript" src="gen_validatorv31.js" type="text/javascript"></script>

<title>Untitled Document</title>
</head>

<body>
<div id="wrapper">
	<!-- start page -->
	<div id="page">
    	  <!-- start content -->
        <div id="prtCnt" align="center">
		<div id="content" align="center">
		  <div class="post">
	    <h2 class="title">&nbsp;</h2>
	    <div class="entry">
<?php	
	$userfinal=$_SESSION['UserName'];

// get the messages from the table.
$get_messages = mysql_query("SELECT message_id FROM messages WHERE to_user='$userfinal' ORDER BY message_id DESC") or die(mysql_error());
$get_messages2 = mysql_query("SELECT * FROM messages WHERE to_user='$userfinal' ORDER BY message_id DESC") or die(mysql_error());
$num_messages = mysql_num_rows($get_messages);
// display each message title, with a link to their content
?>
<table width="95%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="25%" align="center" bgcolor="#E6E6E6"><strong>From</strong></td>
<td width="32%" align="center" bgcolor="#E6E6E6"><strong>Subject</strong></td>
<td width="23%" align="center" bgcolor="#E6E6E6"><strong>Date</strong></td>
<td width="20%" align="center" bgcolor="#E6E6E6"><strong></strong></td>
</tr>
<?php
echo '<ul>';
for($count = 1; $count <= $num_messages; $count++)
{

    $row = mysql_fetch_array($get_messages2);
    //if the message is not read, show "(new)" after the title, else, just show the title.
?>
<tr>
<td width="25%" bgcolor="#FFFFFF"><?php echo $row['from_user']; ?></td>
<td width="32%" bgcolor="#FFFFFF"><?php 
if($row['message_read'] == 0)
{
	$msgid=$row['message_id'];
    echo '<a href="user_read_message.php?messageid=' . $row['message_id'] . '">' . $row['message_title'] . '</a>(New)<br>';


}
else{
echo '<a href="user_read_message.php?messageid=' . $row['message_id'] . '">' . $row['message_title'] . '</a><br>';
}
echo '</ul>' ;?></td>
<?php
$mssg=$row['message_id'];
?>
<td width="23%" bgcolor="#FFFFFF"><?php echo $row['message_date']; ?></td>

<td width="20%" bgcolor="#F8F7F1"><a href="user_delete_message.php<?php echo "?id=$mssg";?>">delete</a></td>
<?php
}
?>

</tr>
</table>


<?php
echo '<form name="newmsgfrm" method="post" action="user_new_message.php">';
echo '<input type="submit" value="Send a New Message">';
echo '</form>';
?> 
 <?php
echo '<form name="backfrm" method="post" action="index_user.php">';
echo '<input type="submit" value="Back to Home" action="index_user.php">';
echo '</form>';
?>


                    </p>
				</div>
		  </div>
		</div>
        </div>
        <!-- end content -->
		<!-- start sidebars -->
		<!-- end sidebars -->
	  <div style="clear: both;">&nbsp;</div>
	</div>
	<!-- end page -->
</div>
</html>
<?php
	include('footer.php');
?>
Return current item: EasyFest