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>