When you look at the properties for your table and see the field you wish to
setup like that. click change on the field.
You can change the field to what you want, just follow the instructions.
If field type is "enum" or "set", please enter the values using this format:
'a','b','c'...
If you ever need to put a backslash ("\") or a single quote ("'") amongst
those values, backslashes it (for example '\\xyz' or 'a\'b').
Thus you can set the options for each field.
Cheers
Jason
-----Original Message-----
From: Phanivas Vemuri [mailto:vas2u@hotmail.com]
Sent: Tuesday, December 17, 2002 3:01 PM
To: bbonkosk@tampabay.rr.com
Cc: php-db@lists.php.net
Subject: Re: here's my problem in PHP & relational tables
hi,
I have two tables.
1.ProgramClips ( id, progSummary, category, videoFile)PRIMkey = id.
and each id may have 2 or three categories.
2.Category( number,category).
categories are :
Beef , diary, horticulture etc;
I am using PhpMyAdmin as the interface for the mySql Database.
The PhpMyAdmin uses a text filed to show the values of the category.
If there are two or more categories for example Beef and Diary then "Beef
| Diary" is shown in the text field.
Now I want to change that text field into a drop down list and enable
multiple selection of the values. And if I want to update the category field
in program clips I will select one or more values in the drop down list and
do some programming to put a pipe symbol in between the selected values ( in
order to make MySQL to understand and interpret).
But my Problem is ... how to say to PhpMyAdmin that u change this particular
field a drop down. How to do that in a general sense, so that it does that
always when I use the values which are unique in another table.
Any idea... if u donot understand my problem ... please mail me ... I will
try to be more clear.
Advance Thanks for the patient people,
Phani.
>From: Brad Bonkoski <bbonkosk@tampabay.rr.com>
>To: Phanivas Vemuri <vas2u@hotmail.com>
>CC: php-db@lists.php.net
>Subject: Re: newbee in PHP-MySQL- help in relational tables
>Date: Sun, 15 Dec 2002 19:11:04 -0500
>
>I would say, that MYSQL is a relational database, thus implying that tables
>would eb relational and this is a DB forum, so just shot, what's the
>problem?
>
>Phanivas Vemuri wrote:
>
> > hi,
> > I need to knwo if anyone had worked on a php interface for relational
>tables
> > in MySql. I have a problem , would be explaning the problem after anyone
> > responds.
> > Thankyou,
> > Phani.
> >
> > _________________________________________________________________
> > The new MSN 8: advanced junk mail protection and 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
