1. <html>
  2. <head>
  3. <title>SimCity 3D Exchange Index</title>
  4. <link rel="stylesheet" href="style.css" />
  5. </head>
  6.  
  7. <body>
  8.  
  9. <?php
  10. include "opendb.php";
  11.  
  12. $sql = "SELECT * FROM tbl_Files ";
  13. $sql .= "ORDER BY filename ASC";
  14. $result = mysql_query($sql, $db);
  15. $rows = mysql_num_rows($result);
  16.  
  17. echo "<table>\n";
  18. echo " <tr>\n";
  19. echo "  <td>Filename</td>\n";
  20. echo "  <td>Type</td>\n";
  21. echo "  <td>Size</td>\n";
  22. echo "  <td>Description</td>\n";
  23. echo "  <td> </td>\n";
  24. echo " </tr>\n";
  25.  
  26. for ($i = 0; $i < $rows; $i++) {
  27.   $data = mysql_fetch_object($result);
  28.   // since our script is very small, i'm not going to escape out to html mode here
  29.   echo " <tr>\n";
  30.   echo "  <td>$data->filename</td>\n";
  31.   echo "  <td>$data->filetype</td>\n";
  32.   echo "  <td>$data->filesize</td>\n";
  33.   echo "  <td>" . stripslashes($data->description) . "</td>\n";
  34.   echo "  <td>( <a href='download.php?fileget=$data->id_files'>Download</a> )</td>\n";
  35.   echo " </tr>\n";
  36. }
  37. mysql_free_result($result);
  38. mysql_close($db);
  39. ?>
  40.  
  41. </body>
  42. </html>