[PHP] enum and set possible values

2001-03-20 Thread Michael George

I'm looking here at the mysql functions for PHP4.0.4 and I'm not finding what
I seek...

I see that mysql_fetch_field() will get information about a field in the
result set from a mysql_db_query().  What I'm wanting to find out is what the
possible values are for an enum or a set.

So if I have an enum with possible values "Yes" and "No" or a set with
possible values "Single", "Married", "Divorced", "Widowed", I seek a function
that will return an array of strings containing those possible values.

Does such a function exist?

I suppose if not it would be possible to write one from the output of a "show
columns from X" query...

Thanks!

-Michael

-- 
No, my friend, the way to have good and safe government, is not to trust it
all to one, but to divide it among the many, distributing to every one exactly
the functions he is competent to.  It is by dividing and subdividing these
republics from the national one down through all its subordinations, until it
ends in the administration of every man's farm by himself; by placing under
every one what his own eye may superintend, that all will be done for the
best.
-- Thomas Jefferson, to Joseph Cabell, 1816

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] enum and set possible values

2001-03-20 Thread CC Zona

In article [EMAIL PROTECTED],
 [EMAIL PROTECTED] (Michael George) wrote:

 So if I have an enum with possible values "Yes" and "No" or a set with
 possible values "Single", "Married", "Divorced", "Widowed", I seek a function
 that will return an array of strings containing those possible values.
 
 Does such a function exist?
 
 I suppose if not it would be possible to write one from the output of a "show
 columns from X" query...

You do the latter.

-- 
CC

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]