getting MySQL column header?

["Aaron Wolski" <aaronjw@martekbiz.com>]

Hey all, 

I have a query (thanks John!)...
 
$query = "select t.manufacturer, t.id, t.colour, t.colourID, t.type,
p.thread_index FROM kcs_threads t LEFT JOIN
kcs_patternthreads p ON t.id = p.thread_index WHERE p.pattern_index =
$id OR p.pattern_index IS NULL
ORDER BY t.colourID";



    $thread_manufacturer = '';



    $result = db_query($query);



    while($thread = db_fetch($result)) {



                //DO STUFF HERE
 
    }






How would one get the column name/header out of this query so that I
could display it as the header for my columns? 

Is this even possible? 

Thanks! 

Aaron