Jump to content

iwpg

Members
  • Content Count

    59
  • Joined

  • Last visited

Community Reputation

0 Neutral

About iwpg

  • Rank
    Regular Member

Profile Information

  • Gender
    Not Telling
  1. Thank you Barand, this is a great solution. Problem solved. I certainly appreciate it!
  2. Hi Benanamen, I need this data to use with highCharts.js, and will plot the data by month. So for example: 2016-05 Revenue: $20 2016-08 Revenue: $10 2016-11 Revenue: $50 How can I populate the empty data where no month exists in between? To chart this out in a way that makes sense, I need this: 2016-05 Revenue: $20 2016-06 Revenue: $0 2016-07 Revenue: $0 2016-08 Revenue: $10 2016-09 Revenue: $0 2016-10 Revenue: $0 2016-11 Revenue: $50 2016-12 Revenue: $0 // This month, or months after last pulled record up until now The records are coming from traffic to a website. T
  3. I have several hundred thousand records that will add a monthly db row if new data exists. I plan on working this info into a chart, but I see no reason to add values that contain 0. For 350,000 records, doing it this way reduces new monthly records to about 8,500, vs 350,000 - a huge performance improvement if this is possible. I figured that an array will help solve this. For example, looping over the data in SQL, will return something like: while ($r = $result->fetch_assoc()){ $id[] = $r["id"]; $revenue[] = $r["revenue"]; // Revenue for example $date[] = $r["date"]; // 2016-0
  4. Thank you for your help, this gives me some nice direction.
  5. Sorry, I have another one as well. {"field25":["0"],"field26":["2"]} I would imagine a preg_split. I basically need to access field25 and field26 values, and turn all of them into variables. This data has me scratching my head, any help is very much appreciated.
  6. I am using a jevents plugin, RSVP pro, and am trying to access "custom_rsvp_capacity" that has a value in this case of 55. Not sure where to start, since this is not a typical set of data. Thank you. Raw: a:45:{s:3:"UID";s:32:"c0c158647d172fafbe9bb23b48b";s:11:"X-EXTRAINFO";s:0:"";s:8:"LOCATION";s:1:"8";s:11:"allDayEvent";s:3:"off";s:7:"CONTACT";s:0:"";s:11:"DESCRIPTION";s:1096:"Discovery Center";s:12:"publish_down";s:8:"2016-9-1";s:10:"publish_up";s:8:"2016-9-1";s:13:"publish_down2";s:8:"2016-9-1";s:11:"publish_up2";s:8:"2016-9-1";s:7:"SUMMARY";s:17:"Falls";s:3:"URL";s:0:"";s:11:"X-CREATEDB
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.