Welcome to the Treehouse Community
Looking to learn something new?
PHP question please help
select the username and the first and last names and alias them as username, first names and last name;
in php you may have two variables:
$firstName = 'Pete'; $lastName = 'Tong';
then to get the username you simply use concatenation:
$userName = $firstName . ' ' . $lastName;
but if this is php and MYSQL then you can create a concatenation of firstName and lastName an give it an alias of AS UserName:
-- The ' ' is a space SELECT CONCAT(firstname,' ', lastname) AS UserName FROM TableName;
Hope this helps.