you could also use the cake way: $this->updateAll() On 21 Apr., 12:44, "[email protected]" <[email protected]> wrote: > Hi Jermy,.. > thanks for reply.... > I have change a little bit but still getting error... > > $this->Guest->query('UPDATE fociki_quests guest_id = ' . $this- > > >user['id'] . ' . WHERE id = ' . $user['User']['id']); > > ?? > can some one help? > thanks > > On Apr 21, 2:56 am, Jeremy Burns | Class Outfit > > > > > > > > <[email protected]> wrote: > > I think you are missing some apostrophes and full stops... > > > $this->User->query('UPDATE fociki_quests SET guest_id = ' . > > $this->user['id'] . ' WHERE id = ' . $user['User']['id']); > > > I'd stick the SQL into a variable first and debug it to screen to check its > > syntax. > > > Jeremy Burns > > Class Outfit > > > [email protected]http://www.classoutfit.com > > > On 21 Apr 2011, at 10:52, [email protected] wrote: > > > > $this->User->query('UPDATE fociki_quests SET guest_id = ' $this- > > >> user['id'] WHERE id = ' . $user['User']['id']);
-- 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
