mysql 一列下拉框显示,从MySQL列数据填充下拉列表

I am currently having trouble displaying the entries in a column of my database in a drop down list.

The code below... is half working i guess...

When I run it, the drop down list gives me 6 options (the column in my database also has 6 columns) Now I just need to get the names to show up!

All help is appreciated!

$pdo = new PDO('mysql:host=localhost;dbname=clubresults', 'root', '12345678');

#Set Error Mode to ERRMODE_EXCEPTION.

$pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$stmt = $pdo->prepare('Select teamname from members');

$stmt->execute();

while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

echo "{$row['teamname']}";

}

?>

解决方案

$pdo = new PDO('mysql:host=localhost;dbname=clubresults', 'root', '12345678');

#Set Error Mode to ERRMODE_EXCEPTION.

$pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$stmt = $pdo->prepare('Select teamname from members');

$stmt->execute();

while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

echo ''.$row['teamname'].'';

}

?>