fetching db column names only, for display in dynamic table using php

Question

in the code below Im searching specific columns from a db table and placing them into a html table, inserting &nbsp for empty db fields to maintain uniformed structure. That part works fine, but Im having trouble figuring out the best way to go about getting the column names that are being searched and dynamically displaying them once at the very top of the html table? If my search changes, the column names displayed on the html table will change with it accordingly. Im fairly new to php/mysql and would appreciate any help guys.

$result = mysql_query('SELECT part, ers, make, model, years, oe, core, inlet, outlet FROM parts LIMIT 3');
echo '<table>';
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    echo '<tr>';
    foreach ($row as $name => $value) {
        if ( $value == "" ) $value="&nbsp;";
        echo '<td> '.$value.' </td>'; 
    }
    echo '</tr>'; 
}
echo "</table>";

Juan · Accepted Answer · 2012-05-10 18:46:25Z

1

How about something like this:

$result = mysql_query('SELECT part, ers, make, model, years, oe, core, inlet, outlet FROM parts LIMIT 3');
echo '<table>';

$cnt = 0;
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    if ($cnt == 0) {
        $columns = array_keys($row);
        echo '<tr><th>' . implode('</th><th>', $columns) . '</th></tr>';
    }

    $cnt++;
    echo '<tr>';

    foreach ($row as $name => $value) {
        if ( $value == "" ) $value="&nbsp;";
        echo '<td> '.$value.' </td>'; 
    }

    echo '</tr>'; 
}

echo "</table>";

answered May 10, 2012 at 18:46

Juan

1,4262 gold badges23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

watercolor12 Over a year ago

thank you so much, i hope I can figure that out that fast one day.

Collectives™ on Stack Overflow

fetching db column names only, for display in dynamic table using php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related