0

I wanna create a pivot table format. I have the update_by_id and campaign_id in the same table. please see the attached image. enter image description here

I need this format

enter image description here

Group By Updated by id and Campaign Id with Lead id total. please check and let me know.

New attached image enter image description here

Rahul rajoria
  • 109
  • 1
  • 6
  • We are always glad to help and support new coders but ***you need to help yourself first. :-)*** After [**doing more research**](https://meta.stackoverflow.com/q/261592/1011527) if you have a problem **post what you've tried** with a **clear explanation of what isn't working** and provide [a Minimal, Complete, and Verifiable example](http://stackoverflow.com/help/mcve). Read [How to Ask](http://stackoverflow.com/help/how-to-ask) a good question. Be sure to [take the tour](http://stackoverflow.com/tour) and read [this](https://meta.stackoverflow.com/q/347937/1011527). – Jay Blanchard Dec 15 '17 at 16:39
  • 1
    https://evolt.org/node/26896 – Jay Blanchard Dec 15 '17 at 16:40
  • Thanks Sure I will take care of it next time. – Rahul rajoria Dec 15 '17 at 16:43
  • Good tutorial link @JayBlanchard would be even better when the topicstarter replaces the deprecated mysql_* functions with mysqli_* functions or PDO. – Raymond Nijland Dec 15 '17 at 16:46
  • Yeah - it is an oldie @RaymondNijland ;-) – Jay Blanchard Dec 15 '17 at 16:52
  • Yes i know i saw the topic date @JayBlanchard – Raymond Nijland Dec 15 '17 at 16:54
  • Please see the attached image not able to get the count of campaign group by username and campaign both – Rahul rajoria Dec 15 '17 at 18:56

0 Answers0