Hello, All -
Is it possible to combine the output from 2 mysql_select calls?
I am trying to create a drop-down select menu which would allow people to create a link to a page (category) or record. I need to grab the results from both tables and present them as one list.
I can do this in the backend using mySQL.
SELECT CONCAT('./', permalink) AS URL, CONCAT(name,' (Page)') AS LINK from cms_pages
UNION
SELECT CONCAT('?rec=', num) AS URL, CONCAT(name,' (Record)') AS LINK from cms_records
ORDER BY LINK
However, on a normal page it is proving more troublesome!
Any suggestions?
:0S
Perch