rendered paste body require_once ('mysql_connect.php');
$query = "select * from users, themes WHERE users.username = themes.username and
valid = 'Valid'";
$result = @mysql_query ($query);
echo "<br><table
width=\"950\"
border=\"1\"
cellpadding=\"3\"
bgcolor=\"#99ccff\"
align=\"center\">";
echo "
<th bgcolor=\"#ffffff\">Username</th>
<th bgcolor=\"#ffffff\">Code</th>
<th bgcolor=\"#ffffff\">Image</th>
<th bgcolor=\"#ffffff\">Comments</th></tr>";
if($num_rows == 0)
{
//Display Error
}
else
{
while($ROW = mysql_fetch_array($result))
{
$ec = htmlspecialchars($ROW[exampleCode]);
echo "<td> $ROW[username] </td>";
echo "<td> $ROW[lesson] </td>";
echo "<td> $ec </td>";
echo "<td> $ROW[browserCode] </td></tr>";
}
}
echo "</table>";