Advertisement
Guest User

Untitled

a guest
Nov 19th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. $sql = "SELECT * FROM Posts";
  2.  
  3. $result = $conn->query($sql);
  4.  
  5. echo "<h1>All</h1>";
  6. echo "<table border='1' width='100%'>";
  7. echo '<tr style="color: red;">';
  8. echo '<td>'. 'id' . '</td><td>' . 'Thread' . '</td><td>' . 'Response' . '</td><td>' . 'Name' . '</td><td>';
  9. echo '</tr>';
  10.  
  11. while($row = $result->fetch_assoc())
  12. {
  13. $threadId = $row['Thread'];
  14. $sql2 = "SELECT * FROM Threads WHERE id=$threadId";
  15.  
  16. $result2 = $conn->query($sql2);
  17.  
  18. $row2 = $result2->fetch_assoc();
  19. $thread = $row2['Title'];
  20.  
  21. echo '<tr>';
  22. echo '<td>'. $row['id'] . '</td><td>' . $thread . '</td><td>' . $row['Response'] . '</td><td>' . $row['Name'] . '</rd>';
  23. echo '</tr>';
  24. }
  25. echo "</table>";
  26. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement