dynamic list

TestSelect.php

I have a select box at lines 24-35 based on a query at lines 3-7.

I have the default option to be “Select Species.”

For some reason, the select box displays blank and when I click on it, it shows the last records in the list, not the first.

I want it to show “Select Species" and then the rest of the list in alphabetical order.

How do I fix this?

Can I get a url to reproduce? I might be able to spot the problem on the live site... I think I already have FTP access.

https://pabirds.org/porc/TestSelect.php

This is probably because of NULL values in your database. When you concatenate any string with a NULL value, it will result in NULL. To avoid this, you can use the COALESCE function. The COALESCE function returns the first non-Null value.

So instead of:
SELECT CONCAT(SPNO, ' - ', CommonName) AS BirdName, SPNO FROM aou_list ORDER BY CommonName ASC

Try:
SELECT CONCAT(Coalesce(SPNO,''), ' - ', Coalesce(CommonName,'')) AS BirdName, SPNO FROM aou_list ORDER BY CommonName ASC