[SOLVED] How to concatenate database field values?

[divadiva]

Experts,

 

I have two fields in database .One is internaltool_id(IN NUMBERS) .Other is externaltool_id(Characters).

 

internaltool_id =11234

externaltool_id=AABC21

 

 

In the web page .I want to see tool_id as  = AA11234.(Combaination of internaltool_id and externaltool_id)

 

How can  I concatenate teh internal and external tool_id and show in the front end?

 

 

<TH><NOBR>Tool</NOBR></TH> 
$terms[$ic]['tool_id'] = $i_row['tool_id'];// How to do concatenation  over here?

 

 

Best Regards,

Diva

[cytech]

Will it always be the first two characters in the externaltool_id?

 

If so:

 

$combined_id = substr($terms[$ic]['tool_id'], 0, 2).$i_row['tool_id'];
echo $combined_id;

[divadiva]

THANKS FOR REPLYING.

But I am  trying to understand your code.

 

<TD VALIGN="TOP"><% substr($terms[$ic]['tool_id'], 0, 2).$i_row['internaltool_id']; %></TD>
//Is it adding the tool_id and internal_id?I mean what is $terms[$ic] doing?

 

 

 

[cytech]

Hello,

 

I'm not sure what its doing either hehe - I got it from your code

 

Try this:

 

<TD VALIGN="TOP"><?php substr($externaltool_id, 0, 2).$internaltool_id; ?></TD>

 

I hope that clears it up a bit.

[phparray]

Here is a method using the mysql concat function instead of making php do it. Just change you select statement.

 

Example:

select concat(internaltool_id,externaltool_id) as ctool_id

 

It will be put together for you in $i_row['ctool_id']

[divadiva]

Experts ,

 

Thanks for replying.

 

 

This worked .

Here is a method using the mysql concat function instead of making php do it. Just change you select statement.

 

Example:

[select]select concat(internaltool_id,externaltool_id) as ctool_id

 

It will be put together for you in $i_row['ctool_id']

 

 

 

But doing concat is giving me a full string form both the database fields .Whereas I want first 2 alphabet from the first field and second full field.

 

inexternaltool_id =12345
externaltool_id =AABBC
Currently I get 12345AABBC.but I want 

ctoolid as 12AABBC .

Here is  my code 

$ic = 0 ;
$terms = array() ;
$string = "SELECT *,concat(inventory.tool_id, inventory.internaltool_id) as ctool_id FROM `quotes_items`LEFT OUTER JOIN `inventory` ON quotes_items.inventory_id = inventory.inventory_id  WHERE quote_id = '$show'";
<TH><NOBR>Tool</NOBR></TH> 
$terms[$ic]['tool_id'] = $i_row['ctool_id'];

 

 

Any suggestions will be appreciated.

 

[flyhoney]

Try this:

 

SELECT
    CONCAT( LEFT(internaltool_id, 1), LEFT(externaltool_id, 1)) as ctool_id

[flyhoney]

Ooops.  I mean this:

 

SELECT
    CONCAT( LEFT(internaltool_id, 2), externaltool_id ) as ctool_id

[divadiva]

Hey Flyhoney Thanks.It worked.