Optimizar tu codigo:
"index.php":
Código PHP:
<?php
if(isset($_SESSION['id']))
{
$id = $_SESSION['id'];
$username = $_SESSION['nick'];
$get_messages = mysql_query("SELECT * FROM messages WHERE to_user='$username' ORDER BY message_id DESC") or die(mysql_error());
if(!mysql_query($get_messages))
{
echo "No Tienes Mensajes";
}else{
while($row = mysql_fetch_assoc($get_messages))
{
if($row['message_read'] == 0)
{
mysql_query("UPDATE messages SET message_read=1 WHERE message_id = $msg");
echo '<a href="msg.php?messageid=' . $row['message_id'] . '">Asunto: ' . $row['message_title'] . ' De: ' . $row['from_user'] . '</a>(Nuevo)<br>';
}else{
echo '<a href="msg.php?messageid=' . $row['message_id'] . '">Asunto: ' . $row['message_title'] . ' De: ' . $row['from_user'] . '</a><br>';
}
}
}
}else{
echo 'Tienes que iniciar sesion.<br />';
}
?>
msg.php:
Código PHP:
<?php
if(!isset($_GET['messageid']))
{
echo "Id Invalido";
}else{
$id = $_GET['messageid'];
if(!is_numeric($id))
{
echo "Id Invalido";
}else{
$q = mysql_query("SELECT * FROM messages WHERE message_id='".$id."'");
if(!mysql_num_rows($q))
{
echo "El Mensaje No Existe";
}else{
$row = mysql_fetch_assoc($q);
?>
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr >
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="2">
<tr>
<td bgcolor="#000088">
<table width="100%" height="104" border="2" cellpadding="0" cellspacing="0">
<tr>
<th width="64" height="24" valign="top" scope="row"><div align="right">Asunto:</div></th>
<td width="691" valign="top"><?=$row['message_title'];?></td>
</tr>
<tr>
<th height="27" valign="top" scope="row"><div align="right">De:</div></th>
<td valign="top"><b><a name="message_id?=<?=$id?>"><?=$row['from_user']?></a></td>
</tr>
<tr>
<th valign="top" scope="row"><div align="right">Mensaje:</div></th>
<td valign="top"><?=$row['message_contents']?></td>
</tr>
</table>
</td>
</tr>
</table>
<?
}
}
}
?>