Problem with internal email system....Help PHP AND MYSQL

[strujillo]

Ok so i created a social networking website for my school, so teachers and fellow students can communiticate easier. Well i created the internal email system and its up and running OK not great but its a start. SOOO, my question is, i created this but when it goes to Mysql it only pulls out the first set of information it sees.

 

Heres the code.

 

 

EMAIL_COMPOSE.PHP

<?php
//sets title
$title="Compose!";
//includes the body file. This has all the style and html elements
include("body.php");
?>
<center>
<P>Sending a message via ABHS Online Community is different! Please view the tutorial.</P>
<form action="send_success.php" method="post" name="email">
<table>
<tr>
		<td>To:</td>
	<td><input  name="to" type="text" size="65" maxlength="70" /></td>
	</tr>
	  <tr>
		<td>Subject</td>
		<td><input name="Subject" type="text" size="65" maxlength="70" /><br /></td>
	  </tr>
	  <tr>
		<td>Message</td>
		<td><textarea name="Message" cols="49" rows="5"></textarea></td>
	  </tr>
	  <tr>
		<td>Options</td>
		<td><input name="send" type="submit" value="Send" /></td>
	  </tr>
</table>

</form>


</center>

 

 

SEND_SUCCESS.PHP

<?php
include("dbconnect.php");
include("email.php");


$to = $_POST['to'];
$from = $_SESSION['myusername'];
$subject= $_POST['Subject'];
$message= $_POST['Message'];

$results="INSERT INTO `abhs`.`messages` (
		`id` ,
		`to` ,
		`from` ,
		`subject` ,
		`message`
		)
		VALUES (
		NULL , '$to', '$from', '$subject', '$message'
		)";

if(mysql_query($results))
{
	echo"<center>";
	echo"Your message was successful!";
	echo"</center>";
}else{echo"Sorry, an error occured, please contact the administrator or try again.";}
?>

</div>

</body>
</html>

 

 

 

EMAIL_INBOX.PHP

<?php
include("dbconnect.php");
$username=$_SESSION["myusername"];
$sql ="SELECT * FROM `abhs`.`messages` WHERE `to`='$username' LIMIT 0 , 30"; 

$result=mysql_query($sql);

$rows=mysql_fetch_array($result);
?>

<table width="500" border="1" cellpadding="5">
  <tr>
    <td bgcolor="#00FFFF">To:   </td>
    <td bgcolor="#CCFFFF"><?php echo $rows['to']; ?></td>
  </tr>
  <tr>
    <td bgcolor="#00FF00">From:   </td>
    <td bgcolor="#99CCFF"><?php echo $rows['from']; ?></td>
  </tr>
  <tr>
    <td bgcolor="#00FFFF">Subject:   </td>
    <td bgcolor="#CCFFFF"><?php echo $rows['subject'];?></td>
  </tr>
  <tr>
    <td bgcolor="#00FF00">Message:   </td>
    <td bgcolor="#99CCFF"><?php echo $rows['message'];?></td>
  </tr>
</table>

[MasterACE14]

try

LIMIT 1 , 30";

instead of

LIMIT 0 , 30";