Advertisement
Guest User

Untitled

a guest
Feb 12th, 2016
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. <?php
  2.  
  3. $selectSQL2 = 'SELECT award, award_giving_body, date FROM awards';
  4.  
  5. if( !( $selectRes = mysql_query( $selectSQL2 ) ) ){
  6. echo 'Retrieval of data from Database Failed - #'.mysql_errno().': '.mysql_error();
  7. }else{
  8. ?>
  9. <table border="2">
  10. <thead>
  11. <tr>
  12. <th>Award</th>
  13. <th>Award Giving Body</th>
  14. <th>Date</th>
  15. </tr>
  16. </thead>
  17. <tbody>
  18. <?php
  19. if( mysql_num_rows( $selectRes )==0 ){
  20. echo '<tr><td colspan="4">No Rows Returned</td></tr>';
  21. }else{
  22. while( $row = mysql_fetch_assoc( $selectRes ) ){
  23. echo "<tr><td>{$row['award']}</td><td>{$row['award_giving_body']}</td><td>{$row['date']}</td></tr>\n";
  24. }
  25. }
  26. }
  27. ?>
  28. </tbody>
  29. </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement