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: [PHP-DB] 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