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
