Re: Return the column names of MySQL table?
| From: | J.F.Kishor | Date: | Wed, 20 Mar 2002 05:07:25 +0000 |
| Subject: | Re: Return the column names of MySQL table? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-89281@lists.php.net to get a copy of this message | ||
Hi,
Try the following,
<?
mysql_connect("DBServer","DBUser","DBPassword");
$queryColumn = mysql("DBName","desc tableName");
$columnCount = //Find out the number of column in the table.
$index=0;
while($index < $columnCount)
{
$columnName = mysql_result($queryColumn,$index,"Field");
echo "<p>Column name ($index) : $columnName</p>";
$index++;
}
?>
On Tue, 19 Mar 2002, Kevin Stone wrote:
> Forgive me for the off topic question. This is a MySQL question.. has
> nothing to do with PHP directly. However I was not able to find an
> answer in the MySQL documentation, on Usenet, or the MySQL mailing list
> archives. Also MySQL.com's mail manager is on the fritz so I can't
> even subscribe to the MySQL email list. Anyway since many of you are
> familiar with SQL this is as good a place to ask this question as any.
>
> I simply need to return a list of column names of a MySQL table. What's
> the syntax to do that?
>
> Thanks,
> Kevin
>
--
- JFK
kishor
Nilgiri Networks