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 [email protected]
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
