Friday, July 20, 2012

Save function not updating the row ?

Hi gurus,

the same code worked fine for all tables except this table "users",

I have an array which contains the user data:

e.g.

<?php
$d = array(
'User' => array(
'id' => 3,
'username' => 'user',
)
);

?>

I check if the user id is exists in the array if it's exists then I set the the model id the same as the id in the array:

<?php
$this->User->id = $d['User']['id'];
?>

Then I use the save function:

<?php
$this->User->save($d);
?>

but I found the the generated query is looks like this, and this happens for all the rows:

(( UPDATE `dbname`.`users` set id=3, `username`='user' WHERE `dbname`.`users`.`id` = '1' ))

I didn't find why it's updating the the first row all the time !!

When I check for the Model id it says it's 3 but when I want to update it updates the row #1 ???

any help ?





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

No comments: