$sql = "SELECT * FROM messages WHERE to_user_id='$to_user_id' LIMIT $offset, $rowsperpage";
$result = mysql_query($sql) or trigger_error("SQL", E_USER_ERROR);
if (empty($numrows))
{
$totalpages = 1;
$error = 'You don\'t have any messages';
}
echo "<br />";
echo "$error" . "<br />";
echo "<br />";
echo '<form action="my_messages.php?from_user_id="$from_user_id"" method="POST">';
echo "<div style=\"float:left; margin-left:5px;\"><input type=\"submit\" name=\"delete\" id=\"button\" value=\"delete\"/></div>";
echo "<table width=980><tr> <td></td><td><b>From</b></td> <td width=120></td>
<td width=120><b>Subject</b></td> <td width=120></td>
<td width=120>Date Sent</td> <td width=120></td>
<td width=120></td> <td width=120></td></tr>";
//Fetch data
while($row = mysql_fetch_assoc($result))
{
//$to_user_id = $_SESSION['id'];
if (isset($_POST['delete']))
{
$msg = $_POST['msg'];
//$from_user_id = $_POST['from_user_id'];
$from_user_id = $_GET['from_user_id'];
$query = mysql_query("DELETE FROM messages WHERE from_user_id='$from_user_id'");
}
echo "<tr>
<td><input type=\"checkbox\" name=\"msg\" value=\"".$row["from_user_id"]."\"></td>
<td>".$row['from_user']."</td> <td></td>
<td>".$row['subject']."</td> <td width=300></td>
<td>".$row['date_sent']."</td> <td></td>
<td></td> <td></td>
<td></td></tr>";
}
echo "</form></table>";