mysql show all column names in array php

Question

I have a mysql table with columns: Date, Jack, John, Amy. I want to show the column names (only the names!) in an array using php.

So the result should be an array like this:

$array = array('Date', 'Jack', 'John', 'Amy');

So when I do echo $array[1]; for example, the output should be 'Jack'.

Any help would be very appreciated.

possible duplicate of Get Only column names as in array mysql — Joe
– Joe, Commented Feb 2, 2015 at 9:02

Sunil Pachlangia · Accepted Answer · 2015-02-02 09:52:42Z

1

Use this code

$table_column = mysql_query("SHOW COLUMNS FROM YourTableName"); 
$tableArr = array();
while($row1 = mysql_fetch_assoc($table_column))
{
    $tableArr[] = $row1['Field'];
}

echo "<pre>";
print_r($tableArr);

edited Feb 2, 2015 at 9:52

answered Feb 2, 2015 at 9:03

Sunil Pachlangia

2,0613 gold badges17 silver badges26 bronze badges

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

1 Comment

Anony123 Over a year ago

how do i display it in an array then?

Collectives™ on Stack Overflow

mysql show all column names in array php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related