It is rarely a good idea to stray from conventions (http://book.cakephp.org/view/22/CakePHP-Conventions) if you can avoid it. Is it too late to re-factor your database? Assuming it is...
You are putting your prefix into the variable that is intended to hold the name of the controller/model. Try: Model: var $name = 'Campaign'; var $useTable = 'campaign'; var $tablePrefix = 'adb_'; //ideally you'd call the table campaigns, then wouldn't need the $useTable or tablePrefix variables Controller: var $name = 'Campaigns'; I'd recommend getting rid of your $uses array because it will hit performance - look up Associations-Linking-Models-Together. Your view folder should be called campaigns. The 'mycampaign.ctp' view you have created will be rendered when you access the controller function 'mycampaign'. Jeremy Burns [email protected] On 30 Apr 2010, at 09:40, Master Ram wrote: > HI. all i am new to cakephp > > i have table name called: adb_campaign > > my contorller is: > my controller Name: compaigns_controller.php > > <?php > class CompaignsController extends AppController { > > //var $tablePrefix = 'adb_';//var $name = "Users"; > var $name = 'adb_' > > var $uses=array('Client','User','Campaign'); > //var $uses=array('User'); > > var $helpers = array('Html', 'Form'); > function mycampaigns() > { > $campaigns = $this->Campaign->find('all'); > $this->set('campaign',$campaigns); > } > > } > ?> > > my modle Name: campaign.php > > <?php > class Campaign extends AppModel { > > // var $tablePrefix = 'adb_'; > var $useTable ='adb_' > > } > ?> > > in the view folder name: campaign > > mycampaigns.ctp > > <?php > $a = array(); > $i=1; > > foreach( $campaigns as $campaign ): > $a[$i] = > $campaign['Campaign']['jobno']; > $i++; > endforeach; > echo $form- >> select('campaign ', $a, 0, > array('style' > => 'width: 50%'),false); > ?> > > > where i made the mistake please help me > > regards: > Master > > 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 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
