Guest User

Untitled

a guest
Jun 25th, 2016
27
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "clayton";
  4. $password = "asdasdaE";
  5. $dbname = "xenforo";
  6. // Create connection
  7. $conn = new mysqli($servername, $username, $password, $dbname);
  8. if ($conn->connect_error) {
  9. die("Connection failed: " . $conn->connect_error);
  10. }
  11. $thread = "SELECT * FROM xf_thread WHERE `node_id` = '2' ORDER BY thread_id DESC LIMIT 4";
  12. $resultthreads = $conn->query($thread);
  13. echo "works";
  14. while ($row = $resultthreads->fetch_assoc()) {
  15.  
  16. echo "
  17. <div class='notice'
  18. <div class='content'>
  19. <h3> ". $row['title']. "</h3>
  20. <span class='pull-left readmore'><a href='http://forums.minealot.com/index.php?threads/". $row['theard_id']."'>Read More</a></span><span class='pull-right author'>By ".$row['username']."</span>
  21. <div class='clearfix'></div>
  22. </div>
  23. </div>";
  24.  
  25.  
  26. }
  27. ?>
Add Comment
Please, Sign In to add comment