Give me an idea to do product display based on category and brand name

i have 2 table

1. product_category - Fields are brand_id,bnd_cat_name,prod_cat_name,prod_img(this image for brand image)

2. product_gallery (productid,bnd_Cat_name,prod_name,name,imageurl,prod_desc,rate)

in brand.aspx page

i displayed 8 brand image which is static and given query string

in category.aspx

I retrieved the product and image from database based on brandname.

Eg : 

finally in  Product.aspx page

retrieved the value based on category and displayed in detailed


Conditions are 
*Each brand name have same category name but different product 
Eg

-> product_category table

 brand_name prod_cat_name    prod_img
      Duravit                            Washbasin                 cat1.jpg
      AmericanStandard             Washbasin              cat1.jpg

-> product_gallery  table

 brand_name prod_cat_name   nam          imageurl
      Duravit                            Washbasin               prod1       image1.jpg
      AmericanStandard             Washbasin              prod2       image2.jpg

i want to display the details like 

if i select the brand name Duravit and display the categorname is washbasin of duravit(should  
not display the americanstandard ) and

should display in product page
prod1 image1.jpg only