JOIN two unrelated SQL tables???
Date: March 23, 2009 04:55PM
This may be a mute/stupid question...
Is there a way to JOIN two SQL tables with unrelated information in a php file that will pass to one dynamic text field in flash?
I have to load information from two unrelated mySQL tables into one dynamic text box for my client. He wants to combine filtered information regarding event registration (a table called "registration") and the latest news from a "news" table. I'm trying to keep from having him having to upload any information twice in the backend php forms we've developed for him. Is this even possible?
The registration columns to be passed are as follows:
id, title, city, state, m,d,y, reg_close_day, reg_close_month, reg_close_year
(There are more that can be passed and filtered through php, so * 'ALL' can be used, I think)
The news columns to be passed are as follows:
id, title, info, link
I'm not looking to merge the information within each other, just put them together in one dynamic text field.