I guess you made a mistake in your form why is it not echo $this->Form->input('period_id'); (note the _id)?
tip: let cake bake your code. this way less mistakes can be made and such as above easily be avoided On 1 Dez., 00:09, GG <jairusk...@gmail.com> wrote: > The form is successfully adding a new entry to the table, the user_id > is correct, however, the period_id is being stored as 0. They are both > int(11). > > Problem:::: I need to tell cake to: store the value of the option > being sent into the period_id column. > Solution::::?????? Thanks for your help! > > Here is my database > > name:students > field1:period_id > field2:user_id > > Here is my StudentsController.php > > public function add() { > if ($this->request->is('post')) { > $this->request->data['Student']['user_id'] = $this->Auth->user('id'); > > if ($this->Student->save($this->request->data)) { > $this->Session->setFlash('Class successfully added.'); > $this->redirect(array('action' => 'index')); > } > } > > $periods = $this->Period->find('list'); > $this->set(compact('periods')); > > } > > Here is my add.ctp View > > echo $this->Form->create('Student'); > echo $this->Form->input('period'); > echo $this->Form->end('Add Class'); > > Here is the source code from Students/add > > <div class="input select"><label for="StudentPeriod">Period</label> > <select name="data[Student][period]" id="StudentPeriod"> > <option value="57">Class 1</option> > <option value="56">Class 2</option> > <option value="52">Class 3</option> > <option value="51">Class 4</option> > <option value="59">Class 5</option> > </select> > </div> -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php