show just the column names from a MySQL command

crmpicco · November 16th, 2006, 10:23 AM

Is there anyway to show just the column names from a MySQL command?

i.e. dont show the type and things like that

www.crmpicco.co.uk
www.ie7.com

harpua · November 16th, 2006, 10:29 AM

Hello, I was just working on this last night

    $query = "SELECT fieldid, field1, field2, field3 FROM YourTABLE WHERE fieldid = '1'";

    $result = mysql_query($query)
            or die("Error.");

    $iNumFields = mysql_num_fields($result);
    echo $iNumFields . "<BR>";

    $row = mysql_fetch_array($result);
    for ($i = 0; $i<$iNumFields; $i++) {
        echo mysql_field_name($result, $i);
    }

Peace
Mike

crmpicco · November 16th, 2006, 01:06 PM

ah, i see what you are doing - but i was meaning from the command prompt when running mysql, e.g.

mysql>

www.crmpicco.co.uk
www.ie7.com

pc2006 · November 26th, 2006, 04:41 PM

u can try "describe table"

crmpicco · November 29th, 2006, 05:01 AM

yeah, describe table_name was what i tried to start with. but it shows all table info

www.crmpicco.co.uk
www.ie7.com

talk2leo · December 7th, 2006, 08:34 AM

select clounmname where columnname like 'field1'

try it

Success is Never Ending,,Failure is Never Final