+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11)
+--- Thread: using Create Select (/showthread.php?tid=77261)
using Create Select - richb201 - 08-08-2020
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?
RE: using Create Select - InsiteFX - 08-09-2020
I would use a MySQLi Temporary Table
SEE: MySQL Temporary Table