Getting column names, without numbers

[Kudose]

Ok, I will admit it. 1,500 some posts and I dont know how to get the column names of a table only.

Here is what I have and my output is. Can someone please help me out here?

$pages = $myDb->dbFetch("SELECT * FROM main_content");
	    $total = count($pages);
	    $pgs = array_keys($pages[0]);
	    print_r($pgs); exit;

Array
(
    [0] => 0
    [1] => sd_home
    [2] => 1
    [3] => sd_scripting
    [4] => 2
    [5] => sd_software
    [6] => 3
    [7] => sd_consulting
    [8] => 4
    [9] => sd_hosting
    [10] => 5
    [11] => sd_contact
    [12] => 6
    [13] => sd_tutorials
    [14] => 7
    [15] => sd_news
    [16] => 8
    [17] => sd_support
    [18] => 9
    [19] => test_page
)

I don't want the 0-9 ... the number of the column in the table.

TIA

[cheerio]

use mysql_fetch_assoc() instead of mysql_fetch_array(), which i assume you are using.

[Roger_Ramjet]

If you just want to know the column names in a given table then there is the mysql list fileds fuction. But as the manula sez:

This function is deprecated. It is preferable to use mysql_query() to issue a SQL SHOW COLUMNS FROM table [LIKE 'name'] statement instead.

Show Columns