Leaderboard

HTH! Good luck.

When your form is submitted (you need a Submit button) the chosen option will be in $_POST['size']

You are trying to create a drop-down list of the items found with your query, correct? Do you want the user to be able to pick just one item or several? If you want to allow multiple picks at once you need to add that option to your select tag and then use an array name for the name attribute of the tag. Then your php can process that array instead of just one item. Look up the tag in an html reference to learn about the multiple select. Then change the name on your select tag to 'size[]' to make it an array. Then in the code that will handle the POST input you will use a loop on the 'size' array to collect all of the items picked.

What, precisely, are the table structures here. Your second query of the UNION above seems to be getting litter dates from the owner table(???). Does your dog table hold every dog from every litter? How do know when an owner still holds a bitch from a particular litter? You mention breeder_id and owner_id - are these diffrerent entities or are the terms interchangeable?