I've put together a start on an html form so anglers that catch a fish with one of our floy tags can report them to us. Each report is inserted into a MySQL table. There are constraints on the table items species code and tag color that only allow values in two other tables in the database. (foreign keys). I'd like to put pulldown menus on the form for those two fields that look up the allowable values from the other tables, but I have only done that before in Perl. There must be a php way of doing that, but I haven't found an example or tutorial on how to do that with php. Do you know of any?
This signature line intentionally blank.