Can someone please help me in writing the exact query, which can give me desired results for the following,
I wrote, \[code\] SELECT tbl_order_detail.order_id, tbl_order_detail.order_title, tbl_order_detail.dealer_id FROM tbl_order_detailLEFT JOIN tbl_order_lead_send_detail ON tbl_order_detail.order_id=tbl_order_lead_send_detail.order_id WHERE tbl_order_detail.order_status = 'Active'\[/code\]and finding the dealer name from one php function that takes dealer_id in it and returns dealer_name (using another mysql query), and count from another mysql querybut it isn't giving my desired output. it's giving output as
But I want the above circled ones in one row only, as everything is same in them, but they are showing many times in the output (why not one).Can someone help me in this?