Ignited DataTables

[eluser]dobbler[/eluser]
Thanks for the update, it's really rocking now!

However, I'm getting this error in firebug when I use a custom filter:

Code:

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  Invalid argument supplied for foreach()</p>
<p>Filename: libraries/Datatables.php</p>
<p>Line Number: 298</p>

</div>{"sEcho":1,"iTotalRecords":"1","iTotalDisplayRecords":"1","aaData":[["4","2011-04-30","19:45:00","Test Gig","Dublin"]],"sColumns":"gigs.id,gigs.gdate,gigs.gtime,gigs.venue,gigs.city"}

This is my code:

Code:

$table = "gigs";
$columns = array("id", "gdate", "gtime", "venue", "city");
$index = "id";
$options["custom_filter"] = "gigs.gdate >= '" . date('Y-m-d') . "'";
$this->load->library("Datatables");
$data['result'] = $this->datatables->generate($table, $columns, $index, $options);

So, as you can see it's returning the correct record but it's not displaying because of the invalid foreach() error.

It works fine without the custom filter.

Not sure why this is happening, any ideas?

Many Thanks,

Rob.

EDIT: I got it going by wrapping the code on lines 298-300 in an if statement:

Code:

if (count($jointables) != 1) {
      foreach($jointables as $jointable_key => $jointable)
        foreach($jointable['columns'] as $jcolumn_key => $jcolumn_val)
          $tabledotcolumn[] = $jointable_key . '.' . $jcolumn_val;
   }

But I'm no expert at php so I'm not sure what other implications this may have but it seems to be working fine.. Maybe there's a more elegant solution?