1. <?php
  2.  
  3.  
  4. /* CONNECTION VARIABLES */
  5. $db_hostname = ""; // Usually "localhost"
  6. $db_username = "";
  7. $db_password = "";
  8. $db_name = "";
  9.  
  10.  
  11. $sql = "SELECT * FROM filename WHERE ORDER BY id DESC LIMIT 0,6";
  12. $result=mysql_query($sql);
  13.  
  14. $row = @mysql_fetch_array($result);
  15.  
  16. $sql = "SELECT * FROM filename ORDER BY id DESC LIMIT 0,6";
  17. $query = mysql_query($sql);
  18. while($row = mysql_fetch_array($query)) {
  19. ?>
  20.  
  21. <div style="width: 900px;">
  22.  
  23. <?php
  24.  
  25. echo $row['filename']; |
  26. echo $row['filetype']; |
  27. echo $row['filesize'];
  28. ?>
  29.  
  30. <a href="download.php?id=<?php echo $row['id']; ?> ">Download</a>
  31.  
  32. </div>
  33.