Cancelado

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

Habilidades: PHP

Ver mais: 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

Acerca do Empregador:
( 16 comentários ) Bournemouth, United Kingdom

ID do Projeto: #587504

24 freelancers estão ofertando em média $62 para este trabalho

agilesols

we can do it.

$50 USD em 1 dia
(209 Comentários)
7.5
DesignSolutionSW

Please check PM.Thanks.

$30 USD em 1 dia
(63 Comentários)
7.0
jeevanoss

Pls see the PMB

$60 USD em 1 dia
(37 Comentários)
6.3
wincent

quick work, ready to start immediately.

$30 USD in 0 dias
(79 Comentários)
6.0
NeoWebSoftware

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

$60 USD in 0 dias
(56 Comentários)
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 dias
(18 Comentários)
5.1
saulwilliams

Lets start, Please check the PMB for more details.

$111 USD em 1 dia
(23 Comentários)
5.0
sureshmca06

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

$30 USD in 0 dias
(12 Comentários)
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 Mais

$50 USD em 1 dia
(15 Comentários)
4.1
khanzakir

Hi, Please see PM.

$50 USD em 1 dia
(9 Comentários)
3.8
developerhari

Hello please check pm

$30 USD em 1 dia
(10 Comentários)
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 Mais

$39.99 USD em 1 dia
(3 Comentários)
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 Mais

$50 USD in 2 dias
(0 Comentários)
0.0
datavisionitc

Dear sir, I can do your job. thanks!

$30 USD in 0 dias
(0 Comentários)
0.0
SkySoftware

Hi Please check PM.

$50 USD em 1 dia
(0 Comentários)
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 Mais

$50 USD em 1 dia
(0 Comentários)
0.0
freelancerJPF

Please go to PM.

$200 USD in 2 dias
(0 Comentários)
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 Mais

$65 USD in 30 dias
(0 Comentários)
0.0
cjgilr

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

$100 USD em 1 dia
(0 Comentários)
0.0
pilgrim87

Hi. Please read your PMB. Thank you.

$40 USD in 0 dias
(0 Comentários)
0.0