Yohanne

so what is the correct syntax for it. i need procedure_id not to distinct because i need procedure_id to get the details of table2

here is my query - trtpay.treatment_payment_id is already group_by - procedure_id is represent as item _id and treatement_payment_id is payment_id but here i get error like syntax to use near 'distinct(treatement_payment_id)as.. left join (select procedure_id, distinct(treatement_payment_id)as tp from episode_payment) as episode on episode.tp = trtpay.treatment_payment_id

i mean is. disregard the table3 at all.

how about this? can i have your query..

wow . . Thank you last one question, how to achieve if i only use table1 and table2 and display the item_name in group_concat. base on payment_id

im not the creator of this db. im a second user actually. i am now creating a report and i found this case.. and im stock here. but do you think theres is no way to achieve this case. since the client want that case...

the query is messy actually an very long, that why i didn't show. there are many table join. my forpus is to get an idea if this case is possible..

Hi coders, this is not the actual of my table but the scenario is the same.. i cannot get the list of the item because conflict, im not sure., i try it many time 10hrs but failed. now i decided to get help from you guys.. Table1 +-----------------------------------------+ | id | item_id | paymen | payment_id | +-----------------------------------------+ | 1 | 1 | 25 | 11 | +-----------------------------------------+ | 2 | 3 | 15 | 11 | +-----------------------------------------+ | 3 | 2 | 75 | 11 | +-----------------------------------------+ | 4 | 5 | 100 | 2 | +-----------------------------------------+ | 5 | 1 | 88 | 1 | +-----------------------------------------+ | 6 | 1 | 25 | 2 | +-----------------------------------------+ table2 +-------------------------+ | item_id | item_name | +-------------------------+ | 1 | RH Beer | +-------------------------+ | 3 | 22Wine | +-------------------------+ | 2 | Iphone4 | +-------------------------+ | 5 | Nokia3210 | +-------------------------+ table3 +-----------------------------------+ | id | name | payment_id | +-----------------------------------+ | 1 | Lim | 11 | +-----------------------------------+ | 2 | Lim | 11 | +-----------------------------------+ | 3 | Lim | 11 | +-----------------------------------+ | 4 | Jhon | 2 | +-----------------------------------+ | 5 | Leo | 1 | +-----------------------------------+ | 6 | Jhon | 2 | +-----------------------------------+ out put should be like this if possible +-----------------------------------------------------------+ | payment total | name | item | +-----------------------------------------------------------+ | 115 | Lim | RH Beer, 22Wine, Iphone4 | +-----------------------------------------------------------+ | 125 | Jhon | RH Beer, Nokia3210 | +-----------------------------------------------------------+ | 88 | Leo | RH Beer | +-----------------------------------------------------------+

just wow.. @Barand why you are like that.. so easy to solve.. for me actually i got whole day like 15hrs.. but actually i follow your 1st statement.. thank you so much..

i have foreach loop for payment list of a client if they fully paid or have a balance, my problem is client has two receipt like payment in cash and payment in card. he/she paid by different date but don't mind the date.. here is my table dbtable scenario uid | name | payment_type | cost | payment | 1 | kim | card | 100 | 100 | 2 | lee | cash | 95 | 95 | 3 | kent | cash | 100 | 50 | 3 | kent | card | 100 | 50 | 4 | iya | cash | 80 | 40 | 4 | iya | card | 80 | 20 | its should be the output uid | name | cash | card | cost | balance | 1 | kim | 0 | 100 | 100 | 0 | 2 | lee | 95 | 0 | 95 | 0 | 3 | kent | 50 | 0 | 100 | 50 |<-this part 100-50 = 50 balance 3 | kent | 0 | 50 | 100 | 0 |<-balance 50-50 = 0 balnce 4 | iya | 40 | 0 | 80 | 40 |<-this part 80-40 = 40 balance 4 | iya | 0 | 20 | 80 | 20 |<-balance 40-20 = 20 balnce need your assistance newbe here for this scenario but i try to resolve but i got failed. i did not get the correct output..

when i add two text field below, branchname and pickdate i got the error message. if (!$json) { $this->session->data['shipping_method'] = $this->session->data['shipping_methods'][$shipping[0]]['quote'][$shipping[1]]; $this->session->data['branchnamed'] = $this->request->post['branchname']; $this->session->data['pickup_dated'] = $this->request->post['pickup_date']; $this->session->data['comment'] = strip_tags($this->request->post['comment']); } $this->response->addHeader('Content-Type: application/json'); $this->response->setOutput(json_encode($json)); error.. SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data OK <b>Notice</b>: Undefined index: branchname in <b>/home/octagon/public_html/ocs_shop/upload/catalog/controller/checkout/shipping_method.php

Hi coders, i have added new fields for store branch and pick-up date, but i cannot insert the data in the said fields. i try many times but i cannot get it. so please help. give me an instruction where i did get wrong.. opecart v2.3

do you have any other solution on it?

i use VAR/CHARs and i think its too late to change it into DATE. its already have data more than 70k.

Yes