[RESOLVED] SELECT fistname, lastname AS fullname

[OniLink]

Hi,

I'm unaware how to: "SELECT (fistname, lastname) AS fullname" and have a space between firstname and last name.

Please help :]

Thanks,
~Oni.

[NogDog]

SELECT CONCAT(firstname, ' ', lastname) AS fullname FROM tablename ...

[OniLink]

Ahhh, I was close.

Thanks a lot for your help,
~Oni.

[OniLink]

SELECT player_id, CONCAT(first_name, " ", last_name) AS name, photo FROM players WHERE grade != "" AND name LIKE "%'.$keyword.'%" ORDER BY last_name, first_name ASC';

I'm now getting an error:
"MySQL Error: Unknown column name in where clause"
Why would that be? Am I not allowed to use "name" in the where clause?

[NogDog]

OniLink wrote:

SELECT player_id, CONCAT(first_name, " ", last_name) AS name, photo FROM players WHERE grade != "" AND name LIKE "%'.$keyword.'%" ORDER BY last_name, first_name ASC';

I'm now getting an error:
"MySQL Error: Unknown column name in where clause"
Why would that be? Am I not allowed to use "name" in the where clause?

Aliases are often not resolved yet when the where clause is evaluated. I guess you could do:

SELECT player_id, CONCAT(first_name, " ", last_name) AS name, photo 
FROM players 
WHERE grade != "" AND CONCAT(first_name, " ", last_name) LIKE "%'.$keyword.'%" 
ORDER BY last_name, first_name ASC';

[OniLink]

Thanks mate, that works :]