MySQL Forums
Forum List  »  General

JOIN two unrelated SQL tables???
Posted by: bridget hornsby
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.

Options: ReplyQuote


Subject
Written By
Posted
JOIN two unrelated SQL tables???
March 23, 2009 04:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.