RE: [PHP] Combining Columns in MySQL for PHP

, July 27, 2002 4:08 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP] Combining Columns in MySQL for PHP > > Thanks for the reply, and I see that I didn't get specific enough (my > fault! > sorry). > > Here's what I want to take from: > > +-+--+ >

Re: [PHP] Combining Columns in MySQL for PHP

Thanks for the reply, and I see that I didn't get specific enough (my fault! sorry). Here's what I want to take from: +-+--+ | col_1| col_2 | +-+--+ | 2.0| 6.8| +-+--+ | 4.1| 8.9| +-+--+ I want to do something like SELECT COMBINE(col_1, col_2) as

RE: [PHP] Combining Columns in MySQL for PHP

> SELECT COMBINE(column_1, column_2) As column FROM column_list; > > Would give me the results of column_1 and column_2 simply by going through > "column". Use CONCAT() where you have COMBINE(). ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http:/

[PHP] Combining Columns in MySQL for PHP

I was wondering if there was any way to get MySQL to combine the specified SELECT columns into one column. i.e., SELECT COMBINE(column_1, column_2) As column FROM column_list; Would give me the results of column_1 and column_2 simply by going through "column". Is there any thing that does this