[thelist] SQL record filtering

[Joshua Olson]

----- 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