hi,
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
