PHP - Email System Not Working.

I have database table EMAIL[e_id,receiver_email,sender_email,email_Subject,date_time,Text_body]

i have displayed sender_email,Email_subject,Date_time in html table
by using
 select sender_email,Email_subject,Date_time from email where receiver_email=$current _user
i need to open email_body by clicking the sender_email
problem is that how can i get value of first cell of table in the same row by clicking any other column
or if you have alternative
as yahoo displayes all emails received in inbox
by clicking any sender it opens that specific email

For my A level ICT i need to create a PHP newsletter email system for which people can sign up from one page and then a admin can log in and send out the email to the people that have signed up. My problem is i also need to attach a PDF to these emails, however i cant work out how to add this into the scripts i have for the newsletter system. Even my teacher cant help me  , please can someone help me    .
The code i have is below.
admin.php
<?php
  //load configuration
  require("config.php");
  
  //connect to database
  @mysql_connect($db_server,$db_user,$db_password) or die("Database server connection failed. Check variables \$db_server, \$db_user and \$db_password in config.php");
  @mysql_select_db($db_name) or die("Selecting database failed. Check variable \$db_name in config.php");
  
  //print header
  echo $header;
?>
<h1><?php echo $title; ?> - Administration</h1>
<hr>
<?php 
  $pwd = $_GET["pwd"];

  //simple login
  if(isset($pwd) && ($pwd == $password)){
    $submit = $_POST["submit"];
    $submit_newsletter = $_POST["submit_newsletter"];
    $del = $_GET["del"];
          
    //insert new address
    if(isset($submit)){
      $name = $_POST["name"];
      $email = $_POST["email"];
      
      @mysql_query("INSERT INTO $db_table (email,name) VALUES ('$email','$name');");
      
      //error occurred
      if(@mysql_error()){
        ?><p>Inserting entry failed: <?php echo @mysql_error(); ?></p>
        <p><a href="javascript&#38;#058;history.back();">Click here to go back.</a></p><?php
      //successful
      }else{
        ?><p>Entry has been inserted successfully. <a href="admin.php?pwd=<?php echo $pwd; ?>">Click here to continue.</a></p><?php
      }
    //delete an entry
    }else if(isset($del)){
      @mysql_query("DELETE FROM $db_table WHERE id=$del;");
      
      //error occurred
      if(@mysql_error()){
        ?><p>Deleting entry failed: <?php echo @mysql_error(); ?></p>
        <p><a href="javascript&#38;#058;history.back();">Click here to go back.</a></p><?php
      //successful
      }else{
        ?><p>Entry has been deleted successfully. <a href="admin.php?pwd=<?php echo $pwd; ?>">Click here to continue.</a></p><?php
      }
    //send newsletter
    }else if(isset($submit_newsletter)){
      $sent = 0;
      $result = @mysql_query("SELECT name,email FROM $db_table ORDER BY email ASC;");
      $subject = $_POST["subject"];
      $message = $_POST["message"];
      
      ?><p>Sending emails to ...</p>
      <ul><?php
      
      //send emails one by one
      while($row=@mysql_fetch_array($result)){
        $name = $row["name"];
        $email = $row["email"];
        
        ?><li><?php echo $name; ?> (<?php echo $email; ?>) ... <?php

        if(@mail($email,$subject,$message,"From: $admin <$admin>\n")){
          ?>sent<?php
          $sent++;
        }else{
          ?>failed<?php
        }
        
        ?></li><?php
      }
      
      ?></ul>
      <p><strong><?php echo $sent; ?> emails sent.</strong> <a href="admin.php?pwd=<?php echo $pwd; ?>">Click here to continue.</a></p><?php
    //print forms
    }else{
       ?><h2>Send newsletter</h2>
       <form method="post" action="<?php echo $_SERVER["PHP_SELF"]; ?>?pwd=<?php echo $pwd; ?>">
         <table>
           <tr>
             <td>Subject:</td>
             <td><input type="text" name="subject" class="fixedwidth"></td>
           </tr>
           <tr>
             <td valign="top">Message:</td>
             <td><textarea name="message" cols="60" rows="20" class="fixedwidth"><?php echo $signature; ?></textarea></td>
           </tr>
           <tr>
             <td>&nbsp;</td>
             <td><input type="submit" name="submit_newsletter" value="Send"></td>
           </tr>
         </table>
       </form>

       <h2>Add an email address</h2>
       <form action="<?php echo $_SERVER["PHP_SELF"]; ?>?pwd=<?php echo $pwd; ?>" method="post">
         <table>
           <tr>
             <td>Name:</td>
             <td><input type="text" name="name" value="" maxlength="255"></td>
           </tr>
           <tr>
             <td>Email address:</td>
             <td><input type="text" name="email" value="" maxlength="255"></td>
           </tr>
           <tr>
             <td>&nbsp;</td>
             <td><input type="submit" name="submit" value="Submit"></td>
           </tr>
         </table>
       </form>

       <h2>Email addresses</h2>
       <table cellpadding="5" cellspacing="2">
         <tr class="header">
           <td><strong>Name</strong></td>
           <td><strong>Email address</strong></td>
           <td>&nbsp;</td>
         </tr>
         <?php
           $result = @mysql_query("SELECT * FROM $db_table ORDER BY email ASC;");
           $colored = false;

           while($row=@mysql_fetch_array($result)){
             $colored = !$colored;
             ?><tr<?php if($colored){ ?> class="colored"<?php } ?>>
               <td width="200"><?php echo $row["name"]; ?></td>
               <td width="200"><?php echo $row["email"]; ?></td>
               <td><a href="<?php echo $_SERVER["PHP_SELF"]; ?>?pwd=<?php echo $pwd; ?>&del=<?php echo $row["id"]; ?>">remove</a></td>
             </tr><?php
           }
         ?>
       </table>
       <?php
    }
  }else{
    //print login form
    echo $login;
  }
  
  //print link to news
  ?><p align="right"><a href="index.php">Newsletter</a></p><?php
  
  //print footer
  echo $footer;

  //close database connection
  @mysql_close();
?>
config.php
<?php
/* ######################## DATABASE ######################## */

  // Database server
  $db_server = "localhost";
  
  // Database name
  $db_name = "zpwebsi1_news";
  
  // Database username
  $db_user = "zpwebsi1_zac";

  // Database password
  $db_password = "powell";
  
  // Database table to store news
  // (will be created automatically)
  $db_table = "easy_newsletter";

/* ##################### CONFIGURATION ###################### */

  // Complete URL of the script
  // (begins with http://, ends with slash)
  $url = "http://www.charsfieldthreehorseshoes.co.uk/alemail.html";
  
  // Password for the administration
  $password = "admin";
  
  // Administrator email address (will be used as sender of
  // the newsletter emails)
  $admin = "zac@zpwebsite.com";

  // Title (will be displayed in the browser's header
  $title  = "Ale Mail";

  // Signature (will be inserted when creating a fresh
  // newsletter but can be changed before submitting)
  $signature  = "\n\n\n\n\n---------------------\nYou receive this email because you have registered with our newsletter $title. Click the following link to unsubscribe: $url";

/* ######################### LAYOUT ######################### */

  // Header to be used on each page
  $header = <<<EOT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <link href="style.css" rel="stylesheet" type="text/css">
    <title>$title</title>
  </head>
  <body>
EOT;

  // Footer to be used on each page
  $footer = <<<EOT
  </body>
</html>
EOT;

  // Login form
  $login = <<<EOT
    <form action="admin.php" method="get">
      Password: <input name="pwd" type="password"> <input type="submit" value="Login">
    </form>
EOT;
?>

And index.php
<?php
  //load configuration
  require("config.php");
  
  //print header
  echo $header;
?>
<h1><?php echo $title; ?></h1>
<hr>
<?php  
  //form submitted
  if(isset($_POST["submit"])){
    //connect to database
    @mysql_connect($db_server,$db_user,$db_password) or die("Database server connection failed. Check variables \$db_server, \$db_user and \$db_password in config.php");
    @mysql_select_db($db_name) or die("Selecting database failed. Check variable \$db_name in config.php");

    $name = $_POST["name"];
    $email = $_POST["email"];
    
    //subscribe
    if($_POST["action"]=="subscribe"){
      //check if name is long enough
      if(strlen($name)<3){
        ?><p>Name must consist of at least 3 characters.</p><?php
      //check if email is valid
      }else if(!eregi("^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}$",$email)){
        ?><p>Email address is not valid.</p><?php
      //check if email already exists
      }else if(@mysql_num_rows(@mysql_query("SELECT id FROM $db_table WHERE email='$email';"))){
        ?><p>Email address exists already.</p><?php
      //insert values
      }else{
        @mysql_query("INSERT INTO $db_table (email,name) VALUES ('$email','$name');");

        //error occurred
        if(@mysql_error()){
          ?><p>An unknown error occurred. Please try again later.</p><?php
        //successful
        }else{
          ?><p>Subscription was successful. Thank you!</p><?php
        }
      }
    //unsubscribe
    }else{
      @mysql_query("DELETE FROM $db_table WHERE email='$email';");

      //error occurred
      if(@mysql_error()){
        ?><p>An unknown error occurred. Please try again later.</p><?php
      //email not found
      }else if(@mysql_affected_rows()==0){
        ?><p>Email address not found.</p><?php
      //successful
      }else{
        ?><p>You have unsubscribed successfully!</p><?php
      }
    }
  }
?>
<form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post">
  <table>
    <tr>
      <td>Your name:</td>
      <td><input type="text" name="name" value="" maxlength="255"></td>
    </tr>
    <tr>
      <td>Your email address:</td>
      <td><input type="text" name="email" value="" maxlength="255"></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type="radio" name="action" value="subscribe" id="action_subscribe" checked> <label for="action_subscribe">subscribe</label>&nbsp;<input type="radio" name="action" value="unsubscribe" id="action_unsubscribe"> <label for="action_unsubscribe">unsubscribe</label></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type="submit" name="submit" value="Submit"></td>
    </tr>
  </table>
</form>
<p align="right"><a href="admin.php">Administration</a></p>
<?php
  //print footer
  echo $footer;

  //close database connection
  @mysql_close();
?>

Hi guys,

I am thinking of create an free email system by sending an messages using with a username. Would I have to store the messages via in mysql?

If I can do that, then I just curious that how would a user delete their messages if their messages is display on php page?

What method would I have to use?

Hello. I've been having trouble with this trade system not working(my friend made it). Most of it is functioning properly, except the part where it's supposed to show your partners pokemon box. Here is the code:

<?php

require_once("top_header.php");

if(!isset($_GET["p"]) && !isset($_GET["id"]) && !isset($_GET["submit"])) {

?>

      <form action="trading.php" method="get">

        Please enter the ID of the person you would like to trade:<br />

        <input type="text" name="p" /><br />

        <input type="submit" value="Continue!" /><br />

      </form>	  

	  <table width=100%>

	            <tr>

            <td class="header">Trade Partners:</td>

            <td class="header">Open Trades:</td>

          </tr>

<?php

$check1 = "SELECT trade_id, starter_id FROM trades WHERE partner_id = $id AND status = 0";

$check2 = mysql_query($check1);

while($row = mysql_fetch_array($check2)) {

$ass = mysql_fetch_array(mysql_query("SELECT username FROM users WHERE id = {$row["starter_id"]}"));

echo "<tr>";

echo "<td class=into>";

echo $ass["username"];

echo "</td>";

echo "<td class=into>";

echo "<a href=trading.php?id={$row["trade_id"]}>View Trade!</a>";

echo "</td>";

echo "</tr>";

}

?>

<tr>

            <td class="header">Created To:</td>

            <td class="header">Options:</td>

          </tr>

<?php

$check1 = "SELECT trade_id, partner_id FROM trades WHERE starter_id = $id AND status = 0";

$check2 = mysql_query($check1);

while($row = mysql_fetch_array($check2)) {

$ass = mysql_fetch_array(mysql_query("SELECT username FROM users WHERE id = {$row["partner_id"]}"));

echo "<tr>";

echo "<td class=into>";

echo $ass["username"];

echo "</td>";

echo "<td class=into>";

echo "<a href=delete.php?id={$row["trade_id"]}>Delete Trade!</a>";

echo "</td>";

echo "</tr>";

}

?>

</table>

<?php

} else if(isset($_GET["p"])) {
$check = mysql_num_rows(mysql_query("SELECT username FROM users WHERE id = ".$_GET['p'].""));
if($check <= 0)
{
echo "Please do not try to trade non existant users!";
include('bottom_layout.php');
die();
}

?>

  <form action="trading.php?submit" method="post">

  <b>Your Pokemon:</b><br>

    <select width="100px" size=15 name="starter[]" multiple="multiple">

      <option value="0" selected>None</option>

<?php

$query = mysql_query("SELECT id, nickname, level FROM pokemon WHERE owner_id= $id AND slot = 7");

while($info = mysql_fetch_assoc($query))

{

?>

     <option value="<?php echo $info["id"] ?>"><?php echo $info["nickname"] ?> level:<?php echo $info["level"]?></option>

<?php

}

?>


    </select>

	<br><br><br>

	<b>Partners Pokemon</b><br>



    <select width="100px" size=15 name="partner[]" multiple="multiple">

      <option value="0" selected>None</option>


<?php

  $p = htmlentities($_GET["p"]);

  $sql = "SELECT id, gender, pokedex_id, type, level FROM pokemon WHERE owner_id = $p AND slot = 7 AND status = 1";

  $starter_pokemon = mysql_query($sql);

 while($row = mysql_fetch_assoc($starter_pokemon)) {

    $name = mysql_fetch_assoc(mysql_query("SELECT name FROM pokedex WHERE id={$row["pokedex_id"]}"));

    $type = mysql_fetch_assoc(mysql_query("SELECT name FROM types WHERE id={$row["type"]}"));

    $name = $type["name"].$name["name"];


?>

       <option value="<?php echo $info["id"] ?>"><?php echo $info["nickname"] ?> level:<?php echo $info["level"]?></option>

<?php

  }

?>

    </select><br />

    <input type="submit" value="Send Trade!" />

    <input type="hidden" name="p_id" value="<?php echo $_GET["p"];?>" />

  </form>

<?php

} else if(isset($_GET["submit"])) {

  $status = 0;

  $partner = mysql_real_escape_string($_POST["p_id"]);

  foreach($_POST["starter"] as $pokemon) {

    $pokemon = mysql_real_escape_string($pokemon);

    $result = mysql_query("SELECT id FROM pokemon WHERE owner_id = $id AND id = $pokemon");

    if(mysql_num_rows($result) == 0 && $pokemon != 0) { 

      $status = 5;

    }

  }

  foreach($_POST["partner"] as $pokemon) {

    $pokemon = mysql_real_escape_string($pokemon);

    $result = mysql_query("SELECT id FROM pokemon WHERE owner_id = $partner AND id = $pokemon");

    if(mysql_num_rows($result) == 0 && $pokemon != 0) { 

      $status = 5;

    }

  }

  $starter_pokemon = json_encode($_POST["starter"]);

  $partner_pokemon = json_encode($_POST["partner"]);

  if($starter_pokemon == "[\"0\"]" && $partner_pokemon == "[\"0\"]") {

    echo "Sorry, one of you has to be trading something!";

  }

  $sql = "INSERT INTO trades (starter_id, starter_pokemon, partner_id, partner_pokemon, status) VALUES ($id, '".mysql_real_escape_string($starter_pokemon)."', $partner, '".mysql_real_escape_string($partner_pokemon)."', $status)";

  mysql_query($sql);

  echo "Trade created!";

} else if(isset($_GET["id"])) {

  $trade = mysql_real_escape_string($_GET["id"]);

  $sql = "SELECT * FROM trades WHERE trade_id = $trade";

  $result = mysql_query($sql);

  $row = mysql_fetch_assoc($result);

  $starter_pokemon = json_decode($row["starter_pokemon"]);

  $partner_pokemon = json_decode($row["partner_pokemon"]);

  echo "<h3>You are Trading:</h3>";

  foreach($partner_pokemon as $pokeid) {

    $pokeinfo = mysql_fetch_assoc(mysql_query("SELECT pokedex_id, gender, type, level FROM pokemon WHERE id = $pokeid"));

    $name = mysql_fetch_assoc(mysql_query("SELECT name FROM pokedex WHERE id = {$pokeinfo["pokedex_id"]}"));

    $type = mysql_fetch_assoc(mysql_query("SELECT name FROM types WHERE id = {$pokeinfo["type"]}"));

    echo $type["name"].$name["name"]." ({$pokeinfo["gender"]}) (Level:{$pokeinfo["level"]})<br />";

  }

  echo "<h3>Your Partner is Trading:</h3>";

  foreach($starter_pokemon as $pokeid) {

    $pokeinfo = mysql_fetch_assoc(mysql_query("SELECT pokedex_id, gender, type, level FROM pokemon WHERE id = $pokeid"));

    $name = mysql_fetch_assoc(mysql_query("SELECT name FROM pokedex WHERE id = {$pokeinfo["pokedex_id"]}"));

    $type = mysql_fetch_assoc(mysql_query("SELECT name FROM types WHERE id = {$pokeinfo["type"]}"));

    echo $type["name"].$name["name"]."({$pokeinfo["gender"]}) (Level:{$pokeinfo["level"]})<br />";

  }

?>

<br><br>

<a href=complete.php?id=<?php echo $row['trade_id']; ?>>Complete the trade!</a><br><a href=delete.php?id=<?php echo $row['trade_id']; ?>>Delete the trade!</a>

</table>

<?php

}

require_once("bottom_layout.php");

?>