I think you want the column headers right??
Header1 header2 header3 <<---- this is what you want right?
data1 data2 data3
data4 data5 data6
echo '<!-- Results Table Header Field Names -->';
for ($k = 0; $k < sizeof($l_row) ; $k++)
{
echo "\t" . '<td>';
echo mysql_field_name($l_results,$k);
echo "</td> \n";
}
As someone pointed out to me, remember to reset your pointer back to 0, else
you'll only get output from row 2 (data4,5 & 6) as the pointer is alreadly
incremented by 1.
use -> mysql_data_seek($l_results,0);
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-----Original Message-----
From: Jackson Miller [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 10:56 PM
To: Jake Johnson; Mysql
Subject: Re: How do I show column names in php?
Try:
$result = mysql_query("SHOW COLUMNS FROM table_name");
while ($row = mysql_fetch_array($result)) {
foreach ($row as $key=>value) {
echo "$key = $value";
}
}
-Jackson
On Wednesday 23 July 2003 9:32, Jake Johnson wrote:
> I am using php and mysql and I want to show the column names. How do I go
> about doing this without hardcoding the headers in my php?
>
> Regards,
> Jake Johnson
> [EMAIL PROTECTED]
>
> ______________________________________________________________________
> Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
> Rims, Car Audio, and Performance Parts.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
