php 下拉菜单选择后读取数据库,PHP-从数据库中获取并存储在下拉菜单中

我似乎无法获得以下代码来创建一个包含来自mysql数据库的数据的下拉菜单. “include(‘connect.php’);”连接到mysql数据库,我知道它在不同的页面上工作.有什么建议？

以下是整个代码.

listCustomer

Find Customer's Albums Page

From a dropdown list of customers, a user should be able to pick a customer and see a list of albums (all fields in the CD table) purchased by that customer.

---

Customer:

101

102

103

104

105

106

107

108

109

110

include('connect.php');

$query = "SELECT Cnum, CName FROM Customer";

$result = mysql_query ($query);

echo "Dropdown";

while($r = mysql_fetch_array($result))

{

echo "$r["CName"]";

}

echo "";

?>