Selecting table column names then display them

Question

I want to select all the column names in specific table. then display them.

I searched and get some results like this one.

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='yourdatabasename' 
AND `TABLE_NAME`='yourtablename';

if I query this one, how to fetch them and display them ? when I fetch data of any table I display them accourding to their column name.

like:

$table = mysql_query("SELECT * FROM table_name");

while($fetch = mysql_fetch_assoc($table))
{
  echo $fetch['id'] . ":" . $fetch['fullname'] . '<br>';
}

[Please, don't use `mysql_*` functions](http://stackoverflow.com/q/12859942/1190388) in new code. They are no longer maintained and are [officially deprecated](https://wiki.php.net/rfc/mysql_deprecation). See the red box? Learn about prepared statements instead, and use [tag:PDO] or [tag:MySQLi]. — hjpotter92, Apr 25 '13 at 11:10

Linga · Answer 1 · 2013-04-25T11:15:27.227

2

Try this

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA WHERE TABLE_NAME = 'my_table';

You can also use

SHOW COLUMNS FROM my_table;

edited Apr 25 '13 at 11:15

answered Apr 25 '13 at 11:10

Linga

10,379
10
52
104

score 1 · Accepted Answer · answered Apr 25 '13 at 11:14

1

$rows = mysql_query("SHOW COLUMNS FROM table_name");

while($row = mysql_fetch_assoc($rows))
{
   echo $row['Field'];
}

answered Apr 25 '13 at 11:14

picios

250
1
6

score 0 · Answer 3 · answered Apr 25 '13 at 11:10

When you mysql_fetch_assoc, you get an array where the keys are the column names:

$table = mysql_query("SELECT * FROM table_name");

while($fetch = mysql_fetch_assoc($table))
{
  foreach ($fetch as $column=>$value) {
      echo $column . ":" . $value . '<br>';
  }
}

score 0 · Answer 4 · answered Apr 25 '13 at 11:12

0

Try using this

for($i = 0; $i < mysql_num_fields($table); $i++) {
    $field_info = mysql_fetch_field($table, $i);
    echo "Column name: $field_info->name";
}

answered Apr 25 '13 at 11:12

chandresh_cool

11,753
3
30
45

Selecting table column names then display them

4 Answers4