Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $selectSQL2 = 'SELECT award, award_giving_body, date FROM awards';
- if( !( $selectRes = mysql_query( $selectSQL2 ) ) ){
- echo 'Retrieval of data from Database Failed - #'.mysql_errno().': '.mysql_error();
- }else{
- ?>
- <table border="2">
- <thead>
- <tr>
- <th>Award</th>
- <th>Award Giving Body</th>
- <th>Date</th>
- </tr>
- </thead>
- <tbody>
- <?php
- if( mysql_num_rows( $selectRes )==0 ){
- echo '<tr><td colspan="4">No Rows Returned</td></tr>';
- }else{
- while( $row = mysql_fetch_assoc( $selectRes ) ){
- echo "<tr><td>{$row['award']}</td><td>{$row['award_giving_body']}</td><td>{$row['date']}</td></tr>\n";
- }
- }
- }
- ?>
- </tbody>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement