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.

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