Completed

Mysql query modification

Hello,

I need to modify a query in a way it will sum the quantity of products that have the same id.

e.g.

product A qty = 9

product B qty = 6

product C qty = 3

Product A and B have the same id, the the query must give :

product A qty = 15

product B qty = 15

Platform oscommerce 2.3.4

Skills: Database Programming, MySQL, OSCommerce, PHP, Software Architecture

See more: mysql update multiple columns, update query in mysql in java, mysql update join, mysql add column, mysql insert, delete query in mysql, update query in mysql, mysql update multiple rows, edit csv mysql query, asp mysql query, 2013 lost connection mysql query, mysql query report, php mysql query table, mysql query record bash, mysql query csv file, write mysql query, optimize mysql query software, mysql query php table css, php mysql query format table, mysql query search

About the Employer:
( 27 reviews ) Kfour, Lebanon

Project ID: #18491998

Awarded to:

dagdya99

Hi, I'm interested to work on your project, I will start project immediately Please let me know if you require any detailed information. Waiting for your reply Thanks Dev

$35 USD in 1 day
(452 Reviews)
7.6
maxtechsl

Hello, i am ready to help you for Mysql quiery modification. I have experience in Osc cart and confident to provide solution. I need clarification, what does id refers too. Please open message board for further discuss More

$20 USD in 1 day
(96 Reviews)
6.5

34 freelancers are bidding on average $27 for this job

mascotindia123

Hi, As discussed, we are can be work on this project there estimate $50. I can be do less ($30), if work would done easily.

$50 USD in 2 days
(241 Reviews)
7.4
softcarve

Hi, I would like to write the query to get the total qty based on id. Available to start now. Looking Forward to your response. Regards, Manish

$15 USD in 1 day
(104 Reviews)
6.1
utkarshkatiyar19

Hi I'm an expert working in SQL. I'm sure that I can easily do this project. We can have a about it. Thanks..

$30 USD in 1 day
(41 Reviews)
5.5
iMezied

مرحبا I can do that for you and write the optimized query to return the quantities waiting for your response

$20 USD in 0 days
(36 Reviews)
5.3
jiitendra

Hi, I have 8 years of experience and reviewed your requirement and I can do this job as per your requirement. I have huge expertise in WORDPRESS, Laravel, Node.Js, React.Js, CakePHP, Codeigniter, Angular.js, Bootst More

$55 USD in 1 day
(33 Reviews)
5.2
xinglong717

Hi. I have read your description and have interests in your project. I have some experience in projects similar to yours. I am ready for your project now. I would like to have a discussion on chat to get more about More

$35 USD in 1 day
(44 Reviews)
5.3
fleedsteed

Hello, sir. It's a pleasure to meet you. I understood your requirements very well. I am a senior backend developer with 10 years of exp. So your job is very easy for me Please award me and let's get your job done. More

$30 USD in 1 day
(22 Reviews)
5.3
kaushikbitrik

Approach: Hi, we understand whole concept ,can give you the exact work and quality that you want ,no upfront, once work finish then and then you need to pay ,just give us a chance to work with you. Benefits To Hire U More

$25 USD in 1 day
(23 Reviews)
5.0
ecommerce22

I have more than 4 years of expreince as web developer. I'm highly interested in this project and I can do this project. This is Ajay. with KUBERTECHNOLABS, a SOFTWARE COMPANY in INDIA, with a phenomenally talent More

$25 USD in 1 day
(21 Reviews)
4.8
ashishcompwiz

Hi, I am expert in PHP, Wordpress, HTML, .NET, Android & iOS, with 3+ years in mobile application development field and also almost 5+ years in website designing field. I am a well experienced web and mobile programmi More

$29 USD in 1 day
(6 Reviews)
3.9
globalmultidev

Hello, I'm interested in doing the query modification for you... it's quite easy .... Couple words about me: I'm an experienced programmer. I've worked for 10 years for programming companies in Romania and now More

$12 USD in 0 days
(20 Reviews)
4.1
Hada36

Hello, Thank you very much post your project. I am very much interested on your [login to view URL] my Experience and Expertise I believe and very confident that I will be able to handle your project efficiently and effect More

$20 USD in 1 day
(11 Reviews)
3.5
donovan6

I'm an sql developer/dba with over 20years experience - I can sort this out for you.

$20 USD in 1 day
(2 Reviews)
3.4
bbbssolutions

I am master in sql writing can solve your problen in a minute as you describe it in the job description. I have 10 years of experience

$15 USD in 0 days
(7 Reviews)
3.1
madanbagara08

Hello there, Hope you doing well, I have read your JD and I can do this. I have more than the 6 years experience in Database Programming, MySQL, OSCommerce, PHP, Software Architecture. Please drop me a ma More

$100 USD in 1 day
(6 Reviews)
3.2
mutokvachi

Hi, Can help you with a fast solution. Just reply [login to view URL] huge experience in php. Waiting for your reply. Thanks

$15 USD in 0 days
(3 Reviews)
2.9
shiyusun180409

hello I read your description carefully. As I am a software developer, I have enough knowledge of software. Although, I have not a review right now because I recently joined freelancer. But I have a wealth of exper More

$23 USD in 1 day
(5 Reviews)
3.0
Sonkusale

I have well experience of PHP, HTML, css, mysql, codeignator, opencart, oscommerce, cakephp, etc. I will try my best to complete the Project well in time with accuracy and satisfied you. I hopefully submitted my propos More

$25 USD in 1 day
(4 Reviews)
2.6
sreenivas2903

Hi. I am expertise in query and fix ur issue in quick time if u really interesting ping me we wil do

$35 USD in 1 day
(5 Reviews)
2.9
aytacsankur

Hello there, I'm new at Freelancer and I'm aiming to gain reputation rather than money. That's why I'm making that low offer for this project. But please don't let that mislead you. I am a computer engineer with nearly More

$10 USD in 1 day
(1 Review)
2.2