title: Temporary Table not always available in Code Igniter?
body: <p>Code Igniter - PHP - Mysql.
  I am working on a Shopping Website, and due to the large number of Products and Client Pricing Options for each Product (inclusion of Discounts at a different rate for each user etc), have created a temporary table when a Client Logs in. 
  The table is creating successfully, however as I navigate thru the site it doesnt always remain persistent.</p>
  
  <p>For eg, If i have a query saying "Select * From Temp_Products" running on each page of the site, it returns an empty set or says Temp_Products doesnt exist on some pages.</p>
  
  <p>I am unable to figure out where the problem is, there seems to be no specific pattern or trigger causing this.</p>
  
  <p>Also, how do e-commerce sites usually implement catalogues &amp; inventry? Any info would be helpful!!</p>
  
  <p>Thanks !</p>