ARGH nightmare!

Richardtagger

trying to make an inbox script where readpage.php is the inbox. and the subject of the message is a link to a page which contains the full message.
IM A REAL NEWBIE SO BE GENTLE 🙂

apologies for the length of code and the lack of quality of the code i really dont no what im doing and i need someone to help me big time 🙂 thanx in advance.

<?php 
session_start(); 
include 'db.php'; 
$username = $_SESSION['username']; 

$query = "SELECT * FROM mail WHERE touser= '$username'"; 
$result = mysql_query($query); 
//now, assuming that each row in $results has these values --> id, fromuser, sub 
?>
html here
<?php 
while($row=mysql_fetch_assoc($result)){ 

echo "<tr>"; 
echo "<td><a href=\"CMail.php\">".$row['fromuser']."</a></td>"; 
echo "<td>".$row['sub']."</td>"; 
echo "</tr>"; 
}
$query = mysql_query("SELECT * FROM mail WHERE sub='.$row['sub'].'");
$msg = mysql_result($query,0,"message");
$_SESSION['msg']=$msg;
?>

mourisj

You have to send the mail-ID to your CMail.php:

echo "<td><a href=\"CMail.php?mail_id=$row['id']\">".$row['fromuser']."</a></td>";

In your CMail.php, you need to have a query like

$query = "SELECT * FROM mail WHERE id=$id";
$msg = mysql_query($query);
etc.

Note about your submitted code:

After the end of your while-loop, you do not have access any more to your result-set (the pointer being at the end), unless you reset it to the beginning with mysql_data_seek($query, 0).

Anyway, I don't understand what you want to achieve with that piece of code. At worst, it has to go into your CMail.php file ???

HTH

JJ Mouris