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 <jeremybu...@classoutfit.com> 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 > > jeremybu...@classoutfit.comhttp://www.classoutfit.com > > On 21 Apr 2011, at 10:52, chris...@yahoo.com 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php