php显示没有列名的mysql表中的所有行数据

Question

I want to display all rows/data from a MySQL table without knowing the column names.

I have the table name but not the column names, and I want to build a grid of the data using the table HTML attribute. I was thinking of using the schema but no idea where to start, any suggestions ?

Answer 1

To get the table structure, use this SQL query:

SHOW COLUMNS FROM table_name;

From there you can then make a query that grabs all data from the table and display it as you want.