Cancelled

merge two mysql tables and rectifiy php code

my website: [url removed, login to view]

we have a price calculator that takes values from two different tables in the database. the query is doing a select and because the tables are now 100,000 rows long - it is taking a long time to bring back the price on the website. therefore i now would like to merge the two tables that run this query.

two tables;

tbl_product - contains all the product data and information for the calculator except for the price and quantity

tbl_product_detail - contains price and quantity.

TASK

1. to merge these two tables together to make sure all products and prices go with the correct data in the adjacent table.

2. to change any php code that may need to be changed due to the changes in merging the table.

This is critical and needs to be done today.

If you can do it today without hassle and know what you are doing. let me know!

Thanks,

Daniel

Skills: PHP

See more: mysql merge tables, daniel price, two , php co, mysql query, merge data, make two, data tables, data merge, daniel, calculator table, together mysql, php data table, needs done today, time today php, query php product, mysql code change data, mysql tables rows, php correct, data merging, website tables, products change prices, mysql product database products, mysql product database, php changes database

About the Employer:
( 16 reviews ) Bournemouth, United Kingdom

Project ID: #587504

24 freelancers are bidding on average $62 for this job

agilesols

we can do it.

$50 USD in 1 day
(209 Reviews)
7.5
DesignSolutionSW

Please check PM.Thanks.

$30 USD in 1 day
(63 Reviews)
7.0
jeevanoss

Pls see the PMB

$60 USD in 1 day
(37 Reviews)
6.3
wincent

quick work, ready to start immediately.

$30 USD in 0 days
(79 Reviews)
6.0
NeoWebSoftware

Hello! I know what I am doing. I can do the tasks 1 & 2. Thank you!

$60 USD in 0 days
(56 Reviews)
5.7
shingweb

HI Daniel, Im a UK based Database and Web Developer. I can get this done as a priority for you. Thanks, Dave

$150 USD in 0 days
(18 Reviews)
5.1
saulwilliams

Lets start, Please check the PMB for more details.

$111 USD in 1 day
(23 Reviews)
5.0
sureshmca06

Hi., Ready to Start now., Please check my PM., Thanks.,

$30 USD in 0 days
(12 Reviews)
4.8
BIOSTALL

Good evening, Web developer here with over 7 years experience. I can easily get this done within a few hours and back to you by close of play today. I am available via MSN, Skype or email for instant communicati More

$50 USD in 1 day
(15 Reviews)
4.1
khanzakir

Hi, Please see PM.

$50 USD in 1 day
(9 Reviews)
3.8
developerhari

Hello please check pm

$30 USD in 1 day
(10 Reviews)
3.2
kymar1n

We have time tonight. We've studied your given requirement. The project you described is quite simple in functionality. We have more then 5 years experience in similar projects. We are Interested in the work and We wou More

$39.99 USD in 1 day
(3 Reviews)
2.4
dufferprogrammer

Hi, Dude you have two options now: I believe 100,000 rows are too lesser to think of a table merge. I can make the query with JOIN fast enough to solve your issues, there are several ways to optimize queries w More

$50 USD in 2 days
(0 Reviews)
0.0
datavisionitc

Dear sir, I can do your job. thanks!

$30 USD in 0 days
(0 Reviews)
0.0
SkySoftware

Hi Please check PM.

$50 USD in 1 day
(0 Reviews)
0.0
klpsoftware

I'll merge the tables, THEN I'll fix your real problem. A single row select query on a table with less than a million rows that is slow? That's wrong. You got a bad select query, improper indexes, or badly set-up ta More

$50 USD in 1 day
(0 Reviews)
0.0
freelancerJPF

Please go to PM.

$200 USD in 2 days
(0 Reviews)
0.0
ssteinberg

I am a professional web developer with over 6 years experience in building websites. Service Description: Experience with developing web applications using the following productivity tools: LAMP (Linux,Apache,MYSQ More

$65 USD in 30 days
(0 Reviews)
0.0
cjgilr

I can finish the project in the time and budgets specified. Please check my profile

$100 USD in 1 day
(0 Reviews)
0.0
pilgrim87

Hi. Please read your PMB. Thank you.

$40 USD in 0 days
(0 Reviews)
0.0