* Thus wrote Greg Donald: > On Wed, 10 Nov 2004 09:04:27 -0900, Chris Lott <chris.lott@xxxxxxxxx> wrote: > > Given a database query thats returns results from a linking (or xref) > > table which includes repetition because of the joins: > > > > +----+--------------------------+----------+ > > | id | title | subject | > > +----+--------------------------+----------+ > > | 1 | Collected Poems of Keats | poetry | > > | 2 | Spy High | suspense | > > | 3 | Sci Fi Spies | suspense | > > | 3 | Sci Fi Spies | sci-fi | > > +----+--------------------------+----------+ > > > > What is the best way to go about displaying this for the user so that > > the record looks "complete": > > > > ID: 3 > > title: Sci Fi Spies > > Subjects: suspense, scifi > > You might normalize the data a bit. agreed! Curt -- Quoth the Raven, "Nevermore." -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php