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