[RESOLVED] column join?

[chucklarge]

is there a way to join same type columns? for example, i might have
3 columns all varchar and want to combine them into one and reference it

ex table
letter - prefix - serial
A - 343 - 59095
T - 334 - 39494

so i would like to combine the columns and return this 'A34359095' or 'T33439494'

I know i could either combine the columns in a 4 column when entering the data, or
combine them after referencing each 3, i am just hoping there is a way to use one reference.

Thanks,
Chuck

[TobyRT]

Are the columns all in one table?

If they are, do a standard select and give each a variable name

then use list() to concatenate them

$result=mysql_query("select col1, col2, col3 from mytable where id='id'") or die ("Error in query.".$result);
while (mysql_num_rows($result) > 0)
{
$row=mysql_fetch_array($result);

$col1=$row['col1'];
//etc

list($col1, $col2, $col3)=$combined;

echo $combined.'<br>';
}

or something like that anyway 🙂

[tomhath]

Just concatenate them:

select letter + prefix + serial as 'Combined' from theTable

[TobyRT]

eheh - now that's even quicker than mine starts jotting cunningness in me notebook