<?php
$path = '/srv/includes';
set_include_path(get_include_path() . PATH_SEPARATOR . $path);
include 'auth.php';
$username = "*";
$password = "";
$db = "***";
mysql_connect('localhost', $username, $password);
mysql_select_db($db);
$query = "SELECT messageId, messageFrom, messageSubject, messageDate FROM cw_message WHERE upper(messageTo) = upper('$uid') && messageStatus = '1'";
$result = mysql_query($query)or die("Could not execute query".mysql_error());
$numRows = mysql_num_rows($result);
mysql_close();
print "You are currently logged in as: <b><u>$uid</b></u>";
print "<br><br>";
print "<table border=\"1\" width=\"672\" id=\"table1\"> <tr> <td width=50 align=\"center\" valign=\"top\"><b>Delete?</b><td width=\"134\" align=\"center\" valign=\"top\"><b>Message From</b></td>
<td align=\"center\" valign=\"top\"><b>Message Subject</b></td>
<td width=\"140\" align=\"center\" valign=\"top\"><b>Message Date</b></td>
</tr>";
$counter = 0;
$alternate = 1;
while ($row = mysql_fetch_array($result))
{
switch ($alternate) {
case 1:
print "<tr>";
//----check box for delete -----
print "<td width=\"50\" valign=\"top\" align=\"center\" bgcolor=\"#ECF5FF\">";
print "<input type=\"checkbox\" name=\"C1\" value=\"ON\"> ";
print "</td>";
print "<td width=\"134\" valign=\"top\" bgcolor=\"#ECF5FF\">";
print " ";
echo $row ['messageFrom']."</td>";
if ($row['messageSubject'] == '') {
print "<td valign=\"top\" bgcolor=\"#ECF5FF\">";
print " ";
print "$a <i>- no subject -</i></a>";
print "</td>";
} else {
print "<td valign=\"top\" bgcolor=\"#ECF5FF\">";
print " ";
print "<a href=./message_review.php?mid=" . $row['messageId'] . ">" . $row['messageSubject'] . "</a></td>";
}
print "<td width=\"140\" valign=\"top\" bgcolor=\"#ECF5FF\">";
echo $row['messageDate']."</td>";
$counter++;
print "</tr>";
break;
//close case = 1
case 2:
print "<tr>";
//----check box for delete -----
print "<td width=\"50\" valign=\"top\" align=\"center\" bgcolor=\"#BBDDFF\">";
print "<input type=\"checkbox\" name=\"C1\" value=\"ON\"> ";
print "</td>";
print "<td width=\"134\" valign=\"top\" bgcolor=\"#BBDDFF\">";
print " ";
echo $row ['messageFrom']."</td>";
if ($row['messageSubject'] == '') {
print "<td valign=\"top\" bgcolor=\"#BBDDFF\">";
print " ";
print "<i>- no subject -</i>";
print "</td>";
} else {
print "<td valign=\"top\" bgcolor=\"#BBDDFF\">";
print " ";
print "<a href=./message_review.php?mid=" . $row['messageId'] . ">" . $row['messageSubject'] . "</a></td>";
}
print "<td width=\"140\" valign=\"top\" bgcolor=\"#BBDDFF\">";
echo $row ['messageDate']."</td>";
$counter++;
print "</tr>";
break;
} //switch statement close
switch ($alternate) {
case 1:
$alternate = 2;
break;
case 2:
$alternate=1;
break;
} //if switch statement end
}
print "</table>";
?>