if i have a table that display the
1 sales for each category(ex cat1, cat2)
2. sales for each product that belongs to a particular category(prod1, prod2 for cat1 or prod3, prod4 for cat2)

   For the first table, i query all category and for the second table i query the the cat number selected by the user.
   How am i going to make the first table link to the second table if the user click the cat1 or cat2 on the first table. if click cat1, then display products for cat1 and if click cat2, display products for cat2

Well, this is pretty straight-forward.

If a user clicks on cat1, then you have that information in PHP from the $_GET array (assuming "click" means "click a link"). You know what category they clicked on, so you modify your product table's SELECT query to include a "WHERE category='{$_GET['category']}'" clause.

If the user has NOT clicked on anything, then there will be no $_GET['category'] variable set, so you display ALL the products for ALL categories.

Does that clear things up for you?


Take care,

Nik
http://www.bigaction.org/

Thanks! i'll try and see how it works.