Need help in creating a customer and retailer table for a price comparison website

[hance2105]

i will explain the scenario as i don't know how to do it and i don't know if someone ever did it before.

I am creating a price comparison website. The customers can add products as their favourites from a list of products. They can also add 4 retailers as their favourites. Both will be stored in 2 tables - tblfavourites and tblfav_retailer. All the retailers have set different prices for the products.

I want to create a table displaying the products set as favourites by the customers and the 4 retailers. Under each retailer, will be displayed the price of the product they set. The total price of products by each retailer will be displayed at the bottom.

Can anyone help me out in creating that?

[hance2105]

i have the following tables

 

tblretprod - id, user_id, prod_id, prod_price

 

tblproduct - prod_id, prod_name, prod_brand, prod_desc, prod_photo

 

tblfavourites - fav_id, prod_id, user_id

 

tblfav_ret - id, user_id, ret_id

 

tblretailer - ret_id, user_id, ret_name, ret_address, ret_phone, ret_fax