Re: UPDATE table

> 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.

or use a cake syntax

$this->User->FokitiGuest->id= $user['User']['id'];
$result = $this->User->FokitiGuest->saveField('guest_id',$this->user['id']);

which is far cleaner.

HTH
mikek

>
> Jeremy Burns
> Class Outfit
>
> jeremyburns@classoutfit.com
> http://www.classoutfit.com
>
> On 21 Apr 2011, at 10:52, chris69m@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
>
>

--
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