|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 |
<style> td { border: 1px solid; } </style> <?php //CHANGE THIS include ('../myconnection/connect.php'); //declare the SQL statement that will query the database //CHANGETHIS $query = "SELECT * FROM [???].[???].[????]"; //execute the SQL query and return records $result = mssql_query($query) or die('A error occured: ' . mysql_error()); if (!$result) { $message = 'ERROR: ' . mssql_get_last_message(); return $message; } else { $i = 0; echo '<html><body><table><tr>'; while ($i < mssql_num_fields($result)) { $meta = mssql_fetch_field($result, $i); echo '<td>' . $meta->name . '</td>'; $i = $i + 1; } echo '</tr>'; while ( ($row = mssql_fetch_row($result))) { $count = count($row); $y = 0; echo '<tr>'; while ($y < $count) { $c_row = current($row); echo '<td>' . $c_row . '</td>'; next($row); $y = $y + 1; } echo '</tr>'; } mssql_free_result($result); echo '</table></body></html>'; } ?> |
