RE: [PHP-DB] getting MySQL column header?
Hey John,
This is another person asking the same question as I did.. & thanks
again for your help.. :)
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 4:24 AM
To: Aaron Wolski; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] getting MySQL column header?
> How would one get the column name/header out of this query so that I
> could display it as the header for my columns?
Honestly, did you read the manual after I told you last time??
$num_fields = mysql_num_fields($result)
for($x=0;$x<$num_fields;$x++)
{ echo mysql_field_name($result,$x); }
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] getting MySQL column header?
>> Honestly, did you read the manual after I told you last time??
Umm.. am I missing something?
I don't believe I've ever asked this question before? If so... my bad.
I did have a gander at the manual and was unsure how I could grab the
header info and not add an additional query to get this info.
*shrugs*
Thanks for the info, though!
Aaron
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: July 21, 2003 4:24 PM
To: Aaron Wolski; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] getting MySQL column header?
> How would one get the column name/header out of this query so that I
> could display it as the header for my columns?
Honestly, did you read the manual after I told you last time??
$num_fields = mysql_num_fields($result)
for($x=0;$x<$num_fields;$x++)
{ echo mysql_field_name($result,$x); }
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] getting MySQL column header?
> How would one get the column name/header out of this query so that I
> could display it as the header for my columns?
Honestly, did you read the manual after I told you last time??
$num_fields = mysql_num_fields($result)
for($x=0;$x<$num_fields;$x++)
{ echo mysql_field_name($result,$x); }
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] getting MySQL column header?
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
