You need to use SHOW COLUMNS FROM table LIKE 'yoursetfieldname'
You can then retrieve the values from the ["Type"] column which will look
like - set('val1','val2'...etc) - you will need to parse this string
Debbie
----- Original Message -----
From: "Henry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 25, 2002 8:57 AM
Subject: [PHP] Getting a mysql set info
> Hi All,
>
> I would like to get at the SET information for a particular field in a
MySQL
> database.
>
> I know how to get the type, length, name and flags alla the manual pages
> but;
>
> If I have a field which is of type SET ('one','two','three','four') how
can
> I get at this information from within PHP in order to generate a
collection
> of checkboxes for setting the field in HTML.
>
> Any Help Much Appreciated
>
> Henry
>
>
>
> --
> 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
