problem pulling information from a database:
Here is the table:
id int(5)
sentfrom int(5)
sentto int(5)
subject varchar(100)
datetime varchar(100)
body text
status varchar(10)
folder int(3)
$userid = global variable thats achieved once you are logged in
$folder = is a global thats pulled from the url like so
http://syc0tests.com/index.php?op=messages&folder=1
[code=php] $sql = "SELECT * FROM messages WHERE sentto='$userid' && folder='$folder'";
$r = mysql_query($sql);
$totalinks = mysql_num_rows($r);
if($totallinks == 0){
echo "<tr><th colspan=5 class=contest align=center><i>";
echo "You have no Messages at this time</i></font></th></tr>";
}
if($totallinks>0){
$msgnum = 0;
$whichbg = 0;
$sql = "SELECT * FROM messages WHERE sentto='$userid' && folder='$folder'";
if($sortby < 2){ $sql = $sql."ORDER BY datestamp DESC"; }
if($sortby == 2){ $sql = $sql."ORDER BY sentfrom ASC"; }
if($sortby == 3){ $sql = $sql."ORDER BY subject ASC"; }
$q = mysql_query($sql);
while($arr = mysql_fetch_array($q)) {
$whichbg=1-$whichbg;
if($whichbg == 1){ $bgcol = "#000000"; } else { $bgcol = "808080"; }
$msgnum++;
$msgdate = $arr['datetime'];
$msgfrom = $arr['sentfrom'];
$msgsubject = $arr['subject'];
$msgnew = $arr['status'];
$mid = $arr['id'];
$sqlb = "SELECT * FROM users WHERE userid ='$msgfrom'";
$rb = mysql_query($sqlb);
$rowb = mysql_fetch_array($rb);
$fromname = $rowb['username'];
echo "<tr>";
if($msgnew == 1){ $msgstatus = "<img src=images/new.png>"; } else { $msgstatus=""; }
echo "<td style=\"text-indent:5px;\">$msgstatus";
echo "<td class=contest><a href=?op=viewmsg&msgid=$mid style=\"text-indent:5px;\">$msgdate</a></td>";
echo "<td class=conteststyle=\"text-indent:5px;\"><a href=?op=viewmsg&msgid=$mid>$fromname</a></td>";
echo "<td class=conteststyle=\"text-indent:5px;\"><a href=?op=viewmsg&msgid=$mid>$msgsubject</td>";
echo "<td><a href=?op=messages&delmsg=1&msgid=$mid><img src=\"images/del.gif\" border=\"0\"></a></td>";
}
}[/code]
