MySQL Forums
Forum List  »  Newbie

obtaining multiple records
Posted by: Chris Schofield
Date: July 24, 2005 10:28AM

I am having a lot of difficulty in trying to access multiple rows in a table. The scenario goes like this:

'config' Table

conf_id (primary key)
storage_id
cont_title
conf_descript
sort_order
visible

Each of the 'conf_id' is different.

The table above as the information I want in it under the mentioned fields. I have set up 2 tables called 'multiconfig' containing:

multiconfig_id (primary key)
storage_id (index)

And 'storage' containing:

storage_id (primary key)
field1
field2
field3
field4
field5

The idea is to link the 'storage' table to the 'config' table via 'multiconfig'. Please could someone help me out !!!

Options: ReplyQuote


Subject
Written By
Posted
obtaining multiple records
July 24, 2005 10:28AM


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.