Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^2: DBI MySQL Join Question

by Jazz (Curate)
on Oct 04, 2009 at 22:44 UTC ( #799131=note: print w/ replies, xml ) Need Help??


in reply to Re: DBI MySQL Join Question
in thread DBI MySQL Join Question

Yes, for the non "ImgTheme" fields, I need only one result. For ImgThemes, I need all results. Ideally, I'd like to do it all of this at once, but think that ImgThemes will probably have to be a separate query.

The big need now is to get RegioName from RegioID on Regio, SourceName from SourceID on Sources, etc., without duplicate Images being given.

Maybe a Dumper output of the structure I need would help:

$VAR1 = { 'SAMPLE' => { 'Regio' => { 'RegioName' => 'VI', 'RegioID' => 22 }, 'Themes' => [ { 'ThemeID' => 512, 'ThemeName' => 'Greek Battles', 'ThemeType' => { 'ThemeCategory' => { 'ThemeCategoryName' => 'Narrative Scenes', 'ThemeCategoryID' => 2 } } }, { 'ThemeID' => 196, 'ThemeName' => 'Alexander the Great', 'ThemeType' => { 'ThemeCategory' => { 'ThemeCategoryName' => 'Characters', 'ThemeCategoryID' => 4 } } }, { 'ThemeID' => 9, 'ThemeName' => 'Darius', 'ThemeType' => { 'ThemeCategory' => { 'ThemeCategoryName' => 'Characters', 'ThemeCategoryID' => 4 } } }, { 'ThemeID' => 17, 'ThemeName' => 'Central Floor Mosaic', 'ThemeType' => { 'ThemeCategory' => { 'ThemeCategoryName' => 'Zones', 'ThemeCategoryID' => 9 } } } ], 'ImageID' => 4, 'ImageName' => 'Battle of Issus Mosaic', 'Insula' => { 'InsulaID' => 96, 'InsulaName' => 'House of the Faun' } } }


Comment on Re^2: DBI MySQL Join Question
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://799131]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (6)
As of 2014-12-28 07:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (179 votes), past polls