[RESOLVED] Comabine two fields into one variable

chrisj8221

$query_2 = "SELECT * FROM cds_users ORDER BY cds_user_company ASC";
$result_2 = mysql_query ($query_2) or die ("query_2 failed to run");

$query_contact = "CONCAT(cds_firstname, cds_lastname) AS name
FROM cds_users";

Sure this is a simple question - but how can I conbine the two lines of code to a single query? The first code is pulling the entire record and the second I am trying to combine the lastname and firstname field into a single var to list.

the output I am assuming will be something like this..

<td align="left"><br><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
' . $row['cds_user_first'] . ', ' . $row['cds_user_last'] . '
</font>
</td>

I am looking for table output like this:

Company Contact

(cds_user_company) (cds_user_first + cds_user_last)

I think you use the CONCAT (cds_user_first, cds_user_last) AS name..

but can't seem to get the syntax right - but maybe I'm not even close...

Thanks in advance for the help. I've spent most of the day trying to figure this out and thought I would ask some of the experts!

Chris

Installer

Try this:

$query = "SELECT cds_user_company, CONCAT(cds_firstname, cds_lastname) " .  

         "AS name FROM cds_users ORDER BY cds_user_company ASC";

chrisj8221

So I read this to query the following..

choose cds_user_company values from that column

combine cds_firsname & cds_lastname values into a single variable called names

FROM the cds_users table,

ORDER BY cds_user_company

is this correct?

chrisj8221

Also - the results give me a "firstlast" with no spaces between them "first last". I'm sure this is once again something simple, but still over my head - sorry for the simple questions.

chris

chrisj8221

Fooled around with it and this seemed to work

$query = "SELECT cds_user_company, CONCAT(cds_firstname, ' ', cds_lastname) " .

"AS name FROM cds_users ORDER BY cds_user_company ASC";

does this look like correct syntax - or just got lucky?

Installer

Your fooling around paid off. 🙂