price comparison database


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


Attached Files:

compare [url removed, login to view] (17.00 KB)

Job Type:

* Programming



* 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: PHP, SQL

See more: php price comparison database, will price, website user database programming, sql price, q find, programming database, php programming price, dbs programming, database programming sql, job price, website comparison, product comparison, price list, price comparison script, price compare, find product script, edit multiple rows php mysql, php product compare script, database javascript, mysql edit database, oscommerce product price, total product price, price comparison list, multiple database, edit mysql rows php

About the Employer:
( 40 reviews ) dublin, Ireland

Project ID: #552489

13 freelancers are bidding on average $135 for this job


Hello, I read your requirements, and viewed your xls file, i totally understand it, It's an easy job for me, let me do it for you, thanks!

$200 USD in 2 days
(155 Reviews)

We can provide you best solution for [login to view URL] start and get it done.

$160 USD in 5 days
(138 Reviews)

Pls see the PMB for details

$180 USD in 6 days
(51 Reviews)

Hello, Please check PMB for details. Regards, Vedang Softwares.

$180 USD in 20 days
(17 Reviews)

Expert Computer engineer, in PHP,My Sql, Can Start Work on Immediately effect.

$200 USD in 4 days
(10 Reviews)

we have 5+ years of experience in web development ,please check pmb for more details

$200 USD in 6 days
(7 Reviews)

Hey, I have had a lot of work with commerce sites, and an extensive background with PHP and mysql. I can produce exactly what you are looking for at a very low price, and in a few days. Some sites I have built ar More

$50 USD in 4 days
(1 Review)

i can do what you want.

$100 USD in 4 days
(1 Review)

[login to view URL] / skype :nexusti

$249 USD in 5 days
(0 Reviews)

I will Complete This Database in maximum 15 days.

$60 USD in 15 days
(0 Reviews)

Hi! I have gone through your requirement and i am glad that i can accomplish this task, i would be more interested to speak to you on IM. Pls give us an opportunity to work with you.

$30 USD in 3 days
(0 Reviews)

I am a PHP programmer with 5 years experience. I have done similar task before. I am a responsible person and must complete the work that suits you. Thanks for your consideration.

$80 USD in 15 days
(0 Reviews)

Hi, We are a group of Web-application designing and developing experts with substantial annual turnover. Some of the websites developed by us are: =>[login to view URL] =>[login to view URL] =>http://www.w More

$60 USD in 4 days
(0 Reviews)