how to display mssql table header in php

Question

PHP

Good afternoon.
It was necessary to display a table on the page along with the title, preferably in one request.
Can you tell me how?
If one is not possible, then how is it better?
Thank you.

Answer 1

About clarification:
You stubbornly do not want to look at PHP help. I cited the mssql_field_name function as an example, and, lo and behold, there is a one-to-one function with the name ... drum roll ... odbc_field_name which also returns the names of the columns based on the result of a query to the database.
Sorry, of course, but it's time for you to start fighting your own laziness.

Answer 2

If you use mysql_fetch_assoc , then you can make one query:

$res = mysql_query('select a, b, c from foo');
$row = mysql_fetch_assoc($res);
print '<table><tr>';
foreach($row as $name => $value) {
    print "<th>$name</th>";
}
print '</tr>';
while($row) {
    print '<tr>';
    foreach($row as $value) {
        print "<td>$value</td>";
    }
    print '</tr>';
    $row = mysql_fetch_assoc($res);
}
print '</table>';

I didn't take my example from here.

Answer 3

SHOW FULL FIELDS FROM <table>