Combine 2 fields and display in 1 box

[The_Walrus]

is it possible to take 2 fields from a record, i.e. first name + last name and combine them, so you could select them from an html select list?

I know how to grab more then 1 field, and I have been able to use php to grab one field or the other and put it in to a list, but I would like it to dispaly both. If so, could you lead me in the right direction?

[Sphynx]

$first = "FirstName";
$last = "LastName";

$fullname = $first." ".$last;

/* OR...without a space in between */

$fullname = $first.$last;

/* SO YOUR SELECT LIST IS SOMETHING LIKE THIS */

<select>
  <option value="something">".$fullname."</option>
  ....
</select>

[xblue]

Hi, you can as well do it right within a mysql query:
SELECT CONCAT(field1,' ',field2) AS fullname FROM table.

[The_Walrus]

the select concat method worked great, I think I will go that way. Thanks again both of you.