PHP显示列表框FirstName和LastName

Question

I am a new web developer by using PHP and MS SQL

I have already created my database on MS SQL as id, FirstName, LastName, etc.

I write a PHP to connect to my database with listbox (drop down) so I want to show FirstName

and LastName in my listbox but now I can show only FirstName

This is my code...

May anyone help me.

Thanks for you help.

Answer 1

You're only printing out the first name in the select box. Maybe try something similar to this.

while($name = $firstnameresult->fetch(PDO::FETCH_ASSOC)) {
    echo "<option value="" . $name['FirstName'] . "">" . $name['FirstName'] . " " . $name['LastName'] . "</option>";
}