MySQL Forums
Forum List  »  General

Can I do this?
Posted by: Kunal Shah
Date: October 29, 2004 01:15AM

I need some help here...
MySQL/Tomcat 5/JDBC

table Events contains information about various events including a column called 'OrgIDs' which is a comma separated list of the IDs of the organizations which are sponsoring an event in Events and a column 'FullName' with the full name of the organization (the sponsor)

table Organizations contacts information about the organizations including ID

I would like to display all the Events and the information about the event including the FullName(s) of the Orgs


TABLE Events ( ID, FullName)
TABLE Organizations (EventID, EventTitle, OrgIDs, EventDescription)

the output:

Event 1: The Really Big Cool Event!
Sponsor IDs: 1,2
Sponsor Names: The Cool Organization, The Big Organization

Description: Blah blah blah blah

............




So I guess my question is how can I associate a list of IDs (which I can turn into a array datatype if neccessary) with the names?

Options: ReplyQuote


Subject
Written By
Posted
Can I do this?
October 29, 2004 01:15AM
October 30, 2004 05:18PM
October 30, 2004 05:25PM


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.