Combine 2 Db Columns with an Array?
| From: | PHP User | Date: | Mon, 13 May 2002 18:42:26 +0000 |
| Subject: | Combine 2 Db Columns with an Array? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-97396@lists.php.net to get a copy of this message | ||
I am trying to find the best way to combine 2 columns in a MySQL Db call into
one by using an array. Ive 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 its title and once by its alternate
title.
I can not find a way to merge the 2 separate columns.
Heres what Im trying to do:
$result = mysql_query("SELECT Title, Alt_Title, Size, Price, More, Comment
ORDER BY title");
//magically combine the title & alt_title into on nice variable called
$Title
//or whatever
while ($db = mysql_fetch_array($result))
{
echo $Title;
}