thegerm

Hi Caltech, WIth MYSQL, you can create a field that accepts only specific values and this may be what you want, something like this [CODE] CREATE TABLE `employee` ( `E_id` smallint(6) NOT NULL auto_increment, `E_Name` varchar(60) character set utf8 collate utf8_unicode_ci default NULL, `E_Schedule` enum('Sun','Mon','Tues','Wed','Thur','Fri','Sat') default NULL, .... PRIMARY KEY …

Funkyash, could you post the working code or explain what you did to get it working. I'm trying to do something very similar, Thanks, thegerm

Hi, I have a HTML/PHP/MYSQL setup where I want to use a value chosen from one HTML <SELECT> to restrict values shown in the next HTML <SELECT>. It's a reasonably common requirement but I just can't get it. A good example is where the user chooses a country and then …