anyone know how to make one of my fields in phpMyAdmin behave like a select (option) field with values pulled from the same column.

i.e. school table has subject column (amongst others) which is always either 'x', 'y' or 'z'.

the values could be hardcoded if it's easier.

the sql for the rowsource would be summit like 'select distinct subject from school' but i'm not sure where to apply it.

many thanks

;p

This is not possible naturally with MySQL (to store data as a select field) however if you were to edit the code for phpMyAdmin you could make that row show up as a select field.

hmmm, might look into it some more.

thanks

does phpMyAdmin not show enum columns as select boxes?
Most other MySQL GUI tools do

yes it does. genius.

Well, you learn something everyday huh.