Re: UPDATE table

you could also use the cake way:
$this->updateAll()

On 21 Apr., 12:44, "chris...@yahoo.com" <chris...@yahoo.com> 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
>
>
>
>
>
>
>
> <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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php