Re: Getting a mysql set info

Thanks Debbie, Your a star Henry "Debbie_dyer" <debbie_dyer@surfanytime.co.uk> wrote in message news:00dc01c2646f$06223dd0$19153c3e@homepc... > 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" <henry@teacake.f9.co.uk> > To: <php-general@lists.php.net> > 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 > > >