price comparison database

• Project ID:

  552489

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

Description
require approx 5 mysql dbs ; 5 php functions to go with the mysql dbs.

dbs - products, categories, products_to_categories, shops, products_to_shops

100 products ; 4 shops ; 15 categories ; 100 products to categories ; 400 shops to products (including a price column)

need some javascript to store a user session so that user can add in many shop_product_items and then get total...

functions - to find 5 prices given 1 product
to find the cheapest of the above items
to find the dearest of the above items
to add the total of more than 1 item for the 5 shops. e.g. 20 items
to find the cheapest basket over all and to give the products of that basket and their shop
Edit
Attached Files:
compare shops.xls (17.00 KB)

Job Type:

* Programming
* PHP
* MySQL
* E-Commerce
* osCommerce

--
on the website we need
1) a list of the products
2) when you click on a product, it shows the product and 4 rows (1 for each shop) with a 4 prices

it gives the total, the cheapest and the dearest product

3) if you click another product it gets listed below the last 4 products for each shop

it gives the total, the cheapest and the dearest product

4) it gives the cheapest products below this also...

let me know what you think.
--
the functions are get_products();
get_prices(product); need to have multiple products listed with multiple prices
total of each product from each shop
cheapest product highlighted in green
dearest product highlighted in red

also the cheapest basket. i.e. product a from shop m, product d from shop o and product e from shop q

the php script will have about 5 - 8 functions
the db will have 5 - 8 functions
the php page will cal the php functions which will manipulate the database

Skills required:

PHP, SQL

Additional Files:

compare+shops.xls