getting MySQL column header?
| From: | Aaron Wolski | Date: | Mon, 21 Jul 2003 19:53:26 +0000 |
| Subject: | getting MySQL column header? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29367@lists.php.net to get a copy of this message | ||
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