How to Create and use dummy table in cakephp

Hi All,

           In my application i am trying to use one table it is dummy table dynamicaly created by me and push some data and do some operations in that and finely i want to delete that table form database.Here i dont have chance to create modal for that table below i will give u php related stuf please help me in cake

                  $sql = "CREATE VIEW filtered_campaign_stores
                               AS 
                                SELECT DISTINCT store_id, campaign_id 
                                FROM campaign_store_dates 
                                WHERE date BETWEEN '$weekStartDate' AND '$weekEndDate'
                                AND store_id IN ($storeIdList)";
                        $this->sql($sql);
 dummy table is : filtered_campaign_stores
 
                        $sql = "SELECT store_id, COUNT(campaign_id) as count
                                FROM filtered_campaign_stores
                                GROUP BY store_id";
                      $campaigns = $this->select($sql);
After doing the above operation i am running the below query

                      $sql = "DROP VIEW filtered_campaign_stores";
                        $this->sql($sql);

HELP ME HOW TO RUN DYNAMIC TABLE WITH CREATION OF MODAL.

THANKS IN ADVANCE
A.RAKESH

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.
 
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en