|
Combine 2 Db Columns with an Array?: msg#01941php.general
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"); //magically combine the title & alt_title into on nice variable called $Title //or whatever while ($db = mysql_fetch_array($result)) { echo ?$Title?; }
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: Timeline for Apache 2 full use?, Rasmus Lerdorf |
|---|---|
| Next by Date: | Re: Apache2, Danny Shepherd |
| Previous by Thread: | Timeline for Apache 2 full use?, Eli White |
| Next by Thread: | Re: Combine 2 Db Columns with an Array?, Chris Knipe |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |