$result = mysql_query("SELECT * FROM uploads WHERE Category='Drama'")
or die(mysql_error()); ?>
<table cellspacing="2" cellpadding="2">
<tr> <th>Title</th> <th>Author</th> <th>File</th></tr>
<?php
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
//<!--Print out the contents of each row into a table-->
echo "<tr><td>";
echo $row['Title'];
echo "</td><td>";
echo $row['Author'];
echo "</td></tr>";
echo $row['File'];
echo "</td></tr>";
}
echo "</table>";

echo "<tr><td><a href=\"";
echo $row['File'];
echo "\">"
echo $row['Title'];
echo "</a>"
echo "</td><td>";
echo $row['Author'];
echo "</td></tr>";

result = mysql_query("SELECT * FROM uploads WHERE Category='Drama'")
or die(mysql_error()); ?>
<table cellspacing="2" cellpadding="2">
<tr> <th>Title</th> <th>Author</th> <th>File</th></tr>
<?php
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
//<!--Print out the contents of each row into a table-->
echo "<tr><td>";
echo $row['Title'];
echo "</td><td>";
echo $row['Author'];
echo "</td><td>";
echo $row['File'];
echo "</td></tr>";
}
echo "</table>";