itchyfeets

cooldude832 - that works like a dream! thankyou so much. you rock

Hi, I have had a hard time searching for clues on this, but maybe someone can help? I'm alright with basic MYSQL statements but this is beyond me: I have two tables I'd like to join but not in a straight forward manner. Table: spreads id (int, auto inc) thumb_asset (int) medium_asset (int) large_asset(int) Table: assets id (int, auto inc) path (varchar) So the idea is that a spread has three asset paths and I'd like to output a list of each spread's asset paths like so: spread 1: foo.gif, bar.jpg, moo.gif spread 2: bar.jpg, foo.gif, moo.gif But without doing loads of SELECTs in a PHP loop. It seems like someone who knows MYSQL would find this easy - please help!