Or if you want to do this within PHP use the mysql_list_fields function. On Tue, 19 Mar 2002, Geoff Hankerson wrote:
> 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: 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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php