'; echo ''; // Print column headers for($i = 0; $i < mysql_num_fields($result); $i++) { $field_info = mysql_fetch_field($result, $i); echo ''.$field_info->name.''; } echo ''; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo ''; foreach ($line as $col_value) { echo ''.$col_value.''; } echo ''; } echo ''; // Free resultset mysql_free_result($result); // Closing connection mysql_close($link); require("footer.html"); ?>