I have added my question , my main Aim at the end of this explanation.

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).


My Question in Precise is
1. is there aby way in realation databases that the values that appear in the FORM are the values from the 'categories' table. If I add more categories then those values can be automatically added into the FORM from whcih I update the 'category' field in 'programClips' table.

MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to