page won't load

[null123]

print("<!-- Content Details Table: Write everything below this line --!>");
print("<td height=\"391\" colspan=\"4\" class=\"lists\">");

          print("<table width=\"92%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" class=\"border\">");
          if (($id == "") && ($type == "")) {
          print("Please use the provided menu links. If you got to this page by using one of the provide menu links please report to the a staff member the link you use to get to this page.");
          exit();
          }
          if($id != "") {
          print("<tr>");
          print("<td class=\"menuheader\" colspan=\"4\">Content Details</td>");
          print("</tr>");
          print("<tr>");
          print("<td class=\"lists\" colspan=\"4\">");
          print("<table width=\"98%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" align=\"center\">");
          print("<tr>");
          print("<td colspan=\"3\">");
          }

          mysql_connect("$host", "$Username", "$Password");
          mysql_select_db("files");
          $result = mysql_query("SELECT * FROM file_data WHERE id=' $id ' ");
          $row = mysql_fetch_array($result);
          if($row > 0) {
          $ftitle = $row['ftitle'];
          $uname = $row['uname'];
          $type = $row['type'];
          $dhits = $row['dhits'];
          $hpage = $row['hpage'];
          $floc = $row['floc'];
          $fsize = $row['fsize'];
          $date = $row['date'];
          $desc = $row['desc1'];
          $greq = $row['greq'];

          print("<p><b><font color=\"#000000\" class=\"rctitle\"><b>$ftitle</b><br>");
          print("<div align=\"left\">");
          print("<table border=\"0\" width=\"0\" height=\"0\">");
          print("<tr>");
          print("<td width=\"201\" height=\"13\"><b>Download Type</b>: Dress up</td>");
          print("<td width=\"212\" height=\"13\"><b>Date Added</b>: $date</td>");
          print("</tr>");
          print("<tr>");
          print("<td width=\"201\" height=\"8\"><b>Download Hits</b>: $dhits</td>");
          print("<td width=\"212\" height=\"8\"><b>Game Req</b>: $greq</td>");
          print("</tr>");
          print("<tr>");
          print("<td width=\"201\" height=\"26\"><b>Homepage</b>:<a href=\"http://$hpage\" target=\"_blank\">Click Here</a> </td>");
          print("<td width=\"212\" height=\"26\"><b><a href=\" $floc \">Download Now");
          print("</b>($fsize kb)</td>");
          print("</tr>");
          print("<tr>");
          print("<td width=\"429\" height=\"125\" colspan=\"2\"><b>Description</b>:<br>");
          print(" $desc</p>");
          print("<a href=\"reportit.php?type=files\">Report File</a>");
          print("</tr>");
          print("<tr>");
          print("<td width=\"204\" height=\"150\">Picture Two.</td>");
          print("<td width=\"209\" height=\"150\">Picture One.</td>");
          print("</tr>");
          print("</table>");
          print("</div>");
          exit();
         }
         if ($type != "") {
         if (!isset($_GET['page'])) {
         $page = 1;
         } else {
           $page = $_GET['page'];
         }
         $max_results = 25;

         $from = (($page * $max_results) - $max_results);

         $Link = mysql_connect($host, $username, $password) or die (mysql_error());
         mysql_select_db('files');
         $Query = "SELECT * FROM file_data WHERE type = '$type' order by ID DESC LIMIT $from, $max_results";
         $result = mysql_query($Query, $Link) or die ( mysql_error());

         while($row = mysql_fetch_array($result)) {

         print("<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"98%\" id=\"AutoNumber1\">\n");
         print("<tr>\n");
         print("<td width=\"36%\" align=\"center\">File Title</td>\n");
         print("<td width=\"35%\" align=\"center\">Author</td>\n");
         print("<td width=\"29%\" align=\"center\">Download times</td>\n");
         print("</tr>\n");

         while ($Row = mysql_fetch_array ($result)) {
         $ftitle = $Row['ftitle'];
         $id = $Row['id'];
         $Author = $Row['uname'];
         $dhits = $Row['dhits'];
          print("<td align=center valign=top width=\"36%\"><a href=\"files.php?id=$id\">$ftitle</a></td>\n");
          print("<td align=center valign=top width=\"35%\">$Author</td>\n");
          print("<td align=center valign=top width=\"29%\">$dhits</td>\n");
          print("</tr>\n");
          }
          print("</td></table>\n");

          $total_results = mysql_result(mysql_query("SELECT COUNT(*) AS NUM FROM file_data"),0);
          $total_pages = ceil($total_results / $max_results);

          if ($page > 1) {
          $prev = ($page - 1);
          echo "<a href=\"files.php\"?type=$type2&page=$prev\"><<Previous</A>";
          }

          FOR($i = 1; $i <= $total_pages; $i++) {
          if(($page) != 1) {
          } else {
          echo "<a href=\"files.php\"?type=$type2&page=$i</a>";
           }
          }

          if($page < $total_pages) {
          $next = ($page + 1);
          echo "<a href=\"files.php?type=$type2&page=$next\">Next>></a>";
          exit();

This page will not load at all 🙁 it stops around 38 or 39% and won't go any farther. I have no idea what's wrong with it.

[Frederick]

For starters, quit using print, that is old style and soon will be obselete.

I will use a portion of your code for example:

if($id != "") { 
echo "
<tr>
    <td class=\"menuheader\" colspan=\"4\">Content Details</td> 
</tr> 
<tr> 
    <td class=\"lists\" colspan=\"4\">
        <table width=\"98%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" align=\"center\">
            <tr> 
                <td colspan=\"3\">
"; 
} 

when commenting your code, do not place it inside of an print or echo.
print("<!-- Content Details Table: Write everything below this line --!>");

/* Content Details Table: Write everything
below this line */

or

// Content Details Table: Write everything below this line