Re: [PHP] Getting a mysql set info
Thanks Debbie,
Your a star
Henry
"Debbie_dyer" <[EMAIL PROTECTED]> wrote in message
00dc01c2646f$06223dd0$19153c3e@homepc">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" <[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
Re: [PHP] Getting a mysql set info
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
[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
