Re: [PHP] Return the column names of MySQL table?
I believe it is: describe tablename; - Original Message - From: "Kevin Stone" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 19, 2002 4:43 PM Subject: [PHP] Return the column names of MySQL table? > 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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Return the column names of MySQL table?
On Tuesday, March 19, 2002, at 05:43 PM, Kevin Stone wrote: > I simply need to return a list of column names of a MySQL table. What's > the syntax to do that? SHOW COLUMNS FROM tablename; Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Return the column names of MySQL table?
Hi, Try the following, Column name ($index) : $columnName"; $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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php