Re: displaying repetitive results
| From: | Curt Zirzow | Date: | Sat, 13 Nov 2004 06:30:14 +0000 |
| Subject: | Re: displaying repetitive results | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-201895@lists.php.net to get a copy of this message | ||
* Thus wrote Greg Donald:
> On Wed, 10 Nov 2004 09:04:27 -0900, Chris Lott <chris.lott@gmail.com> 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."