Mati_1 30 Newbie Poster

I'd like to get all of a mysql table's col names in a select box, and display the selected column name in a table. I just want to select one column at a time to display it in a single column table. I am assuming this can be done with a single query for all columns because they all will be displayed in the same table format. What I did so far is this:

<html> <head> </head> <body> <table id="tbresult"> <tr> <th>Column</th> </tr> <?php

include ("config.php");

$sql = "SHOW COLUMNS FROM mytable";

$result = mysqli_query($conn,$sql);

while($row = mysqli_fetch_array($result)){
 echo "<tr><td>" . $row["Column"] ."</td></tr>";
}

    echo "</table>";

} else { echo "0 results"; }
$conn->close();

    ?> </table>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.