using Create Select

I am using Koolreport and it seems to require a table to load fields from prior to generating charts and graphs. I am considering building specific tables with a prefix of the userid-campaign of the user, prior to running koolreport. Of course I would need to delete any old copy of the table with the same name, prior to doing this.  The reason for this prefix thing is that this is a multi-user system. 

Anyone have any input on doing this? I of course would like to run query's and populate an array without going to disk, but I am just not sure koolreport supports that. 

Any architectural ideas? Am I about to step into dog poop?

proof that an old dog can learn new tricks

I would use a MySQLi Temporary Table

SEE: MySQL Temporary Table

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )