Re: Combine 2 Db Columns with an Array?

On 13 May 2002, PHP User wrote:
> I am trying to find the best way to combine 2 columns in a MySQL Db call into
> one by using an array. I?ve tried array_push, implode, explode, array_merge 
> and
> extract all with no luck. I feel I am close but have read all I can and still 
> am
> hitting a dead end.
> I need to select a Title and Alternate title from a table, and then list the
> results by BOTH the Title and Alternate Title. So the list that gets echoed 
> out
> would be a combined array of the Title column and the Alt_Title column. The 
> idea
> is to have each item listed twice, once by it?s title and once by it?s 
> alternate
> title.
> I can not find a way to merge the 2 separate columns.
> Here?s what I?m trying to do:
> 
> $result = mysql_query("SELECT Title, Alt_Title, Size, Price, More, Comment
> ORDER BY title");

select concat (title, ' (', alt_title, ')') as title, size,
  price, more, comment from table order by title;

miguel


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php