I am trying to simply display two fields from a table, e.g. firstname, lastname, combine them and display in a dropdown menu that can be selected, and is stored along with other data the user inputs. Below, works for one fields, but i am struggling to combine the lastname, i have tried concat but i think i did that wrong. Thanks in advance.

```
//Drop Down Select
  $sql = "SELECT concat (firstname, lastname) as username  FROM users_tbl";
$result = pg_query($sql);
echo "<select name='firstname'>";

while ($row = pg_fetch_array($result)) {
 echo "<option value='" . $row['firstname'] . "'>" . $row['firstname'] ."</option>";

}
echo "</select>";
// close connection

```