associated data

[fazzfarrell]

i have two databases

 

CREATE TABLE `holdbacks` (
  `ID` int(11) NOT NULL auto_increment,
  `ProdRel` text NOT NULL,
  `Style` text NOT NULL,
  `Type` text NOT NULL,
  `Name` text NOT NULL,
  `Lemgth` text NOT NULL,
  `CatID` text NOT NULL,
  `Pix` text NOT NULL,
  `Misc` text NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;


CREATE TABLE `poles` (
  `ID` int(11) NOT NULL auto_increment,
  `ProdRel` text NOT NULL,
  `Style` text NOT NULL,
  `Type` text NOT NULL,
  `Name` text NOT NULL,
  `Lemgth` text NOT NULL,
  `CatID` text NOT NULL,
  `Pix` text NOT NULL,
  `Misc` text NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

 

The poles are the main products, the holdbacks are associated products.

 

I want to display the poles on the page via the 'Type' Which I have (the ref is 'E') but I want under each entry. the associated products which comes from the Holdbacks table. Each pole and holdback has a ProdRef (eg 1,2,3 or 4 etc).

 

 

any one help?

 

[fenway]

Well, you can get back all of the pairings with a JOIN, but you'll still have to handle the "each entry" part yourself.

[fazzfarrell]

? Not sure what you mean?

[fazzfarrell]

Dont know if I explained my self properly, I need to end up with all my products on a page then a drop down menu displaying the colours for each product

 

 

[fenway]

What i meant was that you can join the products & product colours, and get a result set of all of the pairs.  However, you'll have to keep track of when the product name changes as you iterate though the result set, so that you can deal with the output accordingly.