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


----- Original Message -----
From: "Henry" <[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
> 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
> I get at this information from within PHP in order to generate a
> of checkboxes for setting the field in HTML.
> Any Help Much Appreciated
> Henry
> --
> PHP General Mailing List (
> To unsubscribe, visit:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to