Philip thanks for the tip-off to the mysql_list_fields() function.. that
simplifies things quite a bit. Problem solved. :)
I'm still wondering about the other method though. I noticed the
"DESCRIBE table_name" method in the MySQL docs but couldn't figure out
how to use it. Alone it seems to return information about only the
first column...
<?
$query = "DESCRIBE montileaux_events ";
$result = mysql_fetch_array(mysql_query($query))
foreach ($result as $key => $val)
{
echo "$key : $val <br>";
}
?>
----------- returns -------------
0 : keynum
Field : keynum
1 : int(11)
Type : int(11)
2 :
Null :
3 : PRI
Key : PRI
4 :
5 : auto_increment
Extra : auto_increment
6 : select,insert,update,references
Privileges : select,insert,update,references
----------------------------------
keynum is the name of the frist column in the table. But beyond that
there doesn't appear to be any data to increment through. The function
returns this and only this. Am I using it wrong?
Thanks,
Kevin
-----Original Message-----
From: Philip Hallstrom [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 4:02 PM
To: Geoff Hankerson
Cc: Kevin Stone; [EMAIL PROTECTED]
Subject: [PHP] Re: Return the column names of MySQL table?
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
