need help guys

[Richardtagger]

i have this code:

<?
session_start();
include 'db.php';
$search = $_SESSION['username'];
    $query = "select * from mail WHERE touser='$search'"; 
    $result = mysql_db_query("sheetshare", $query); 
    if  ($result) 
    { 
    echo "<table width=60% align=center border=1 bordercolor=#111111 style=border-collapse: collapse><tr> 
        <font face='Tahoma'>
		<td align=left bgcolor=#FFFFFF><font face='Tahoma'>From</td> 
        <td align=left bgcolor=#FFFFFF><font face='Tahoma'>Subject</td> 
        </tr></font>"; 

    while ($r = mysql_fetch_array($result)) {     // Begin while 
		$fromuser = $r["fromuser"]; 
        $sub = $r["sub"]; 
		$message = $r["message"]; 
		$Text = "<a href=CMail.php>$fromuser</a>";
		$Text2 = "<a href=readmsg.php>$sub</a>";
              echo "<tr>
			  		<td align=left>$Text</td> 
                    <td align=left>$Text2</td>"; 
    }                  // end while 
    echo "</table>";
 } else { echo "<font face='Tahoma'>Error, Contact Webmaster at SheetShare."; } 
?>

that produces a table like it should, but i want the readmsg.php to display the message accordint to which mail you clicked on. the sender or fromuser of the mail is a link to CMail.php which is compose as to reply to a mail, but the subject is a link to readmsg.php. I want to store the message accordint to whcih line you click on in a session. As there are mulitple rows i dont know how to do this.

thanx in advance.

[ZibingsCoder]

Though I don't know the layout of your table mail, if you have an index value on the table (which you should), perhaps something called mail_id, you can do something like this:

            $fromuser = $r["fromuser"];  

            $sub = $r["sub"];  

            $message = $r["message"];  

            $id = $r['id'];
            $Text = "<a href=CMail.php>$fromuser</a>"; 
            $Text2 = "<a href=readmsg.php?mail=$id>$sub</a>";

Then, inside readmsg.php...

if ( isset($_GET['mail']) && !empty($_GET['mail']) )
{
   $string = "SELECT * FROM `mail`WHERE `mail_id`='$_GET['mail']'";
   //blah blah
}

Hope this helps.