Php pulldowns from MySQL tables

software development


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.


Getting this working now. Dreamweaver 2004 does this, but in a very obtuse way. I’m learning by examining the code DW generates.

This signature line intentionally blank.