Gah, really stuck!

Richardtagger

i HAVE AN INTERNAL MAILING SYSTEM, SO FAR (oops caps) so far, it counts the rows to show how much mail you have and you can send mail. the code so far is to look at your mails is,

<?php

include 'db.php';

$username = $_SESSION['username'];

$result = mysql_query("SELECT * FROM mail WHERE touser='$username'");

$idquery = mysql_query("SELECT id FROM mail WHERE touser='$username'");
$id = mysql_result($idquery,0,"id");

$fromuser = "fromuser Where id='$id'";

$sub = "sub Where id='$id'";

if ($result)

{

echo "Here are the results: ";

echo "<table width=90% align=center border=1 bordercolor=#111111 style=border-collapse: collapse><tr>

<td align=center bgcolor=#FFFFFF>From</td>
<td align=center bgcolor=#FFFFFF>Subject</td>
</tr>";

while ($r = mysql_fetch_array($result))  
{  
    $from = $r["from"];  
    $sub = $r["sub"];  
    echo "<tr> 
                    <td align=center>$from</td> 
                    <td align=center>$sub</td>";  
    }                  // end while 
    echo "</table>";

}

else

{

echo "Error, Contact Webmaster at SheetShare.";

}

?>

That should whow who they are from and the subject.
I cant see the prob...?
Iv included a zip file with the mailing system in it.

TheDefender

That should show who they are from and the subject.
I cant see the prob...?

Neither can we... How's about telling us what this script is actually doing, as opposed to what it should be doing, so we can help troubleshoot it.

Richardtagger

it is designed to be like the inbox of a mail for eg hotmail. One column shows who its from, the other shows the subject.

So its retrieving data from the database where session username is equal to anything in the touser coloum of the databse. its then supposed to echo the subject where session username is equal to username.

In concept thats it. Dunno how i can fix this.

The error is get is the cant jump to row 0 sql error.