Re: displaying repetitive results

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



* 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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux