phpmyadmin

[toles]

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.

[BigDaddy71]

Originally Posted by toles

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.

Well, there is a way to do it in MySQL, but it's a bit on the advanced side. Is there any reason why your code couldn't enforce these rules (always either x, y or z)?