[thelist] SQL record filtering

[dn at dittodesign.co.uk]

There is only one table used in the database hopefully making
it very simple.

It hasn't been normalised in any way. The relevant Fields
include

phone model, phone make, Master category, category
and ID

So for example Master Category contains fascias, cases, handsfree etc
with related categories in the Category field containing (for fascias)
genuine fascias, football fascias, fashion facias etc

thanks

Darren

----- Original Message -----
From: "Joshua Olson" <joshua at waetech.com>
To: <thelist at lists.evolt.org>
Sent: Wednesday, September 11, 2002 3:23 PM
Subject: Re: [thelist] SQL record filtering


> ----- Original Message -----
> From: <dn at dittodesign.co.uk>
> Sent: Wednesday, September 11, 2002 9:45 AM
>
> > If that makes sense few to many products me thinks.
> > Maybe this url will make it a little clearer -
> >
> >
>
http://www.simply-connect.info/accessories_category.asp?Phone_Make=Nokia&Mas
> > ter_Category=Fascias&Phone_Model=3330
> >
> > as you can see I get all records returned and would like just one from
> > each of the categories listed that could then be clicked on to show the
> > rest in that category.
>
> As Karen mentioned, the actual database structure will change the
landscape
> of the problem.  Can you please give us some details about the tables
> involved in categories, product types, products, and the association
between
> products, categories, and product types.
>
> Thanks.
>
> -joshua
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !
>