PHP/MySQL Concat

[poscribes]

I am having trouble getting the following to work. This is the first time I have tried to use the concat function and although I got it to work at the sql prompt I cannot get it to work within a PHP script. Any help appreciated. Here's the line in question:

mysql_query("select concat_ws(' - ','department','asset') as depasset from setup");

[LordShryku]

What's it doing? With the single quotes, it's going to concat those words literally, not pick up the fields.

[devinemke]

that query will simply return the literal "department - asset". are you sure that's what you want. i think you probably want this:

$result = mysql_query("SELECT CONCAT_WS(' - ', department, asset) AS depasset FROM setup");
if (!$result) {exit(mysql_error());}

[poscribes]

I tried the concat you suggested and although it appears to run correctly with no errors it does not concat the two values for department and asset. Any other suggestions?