Hi everybody, this ones been doing my head in for some time now, hope
you can help me out, im sure its very simple but i just cant get it
working. Firstly the table structure is like this:
CREATE TABLE pil (
id int(11) unsigned NOT NULL auto_increment primary key,
user_id int(11) unsigned not null,
pilid int(11) unsigned NOT NULL,
pcode varchar(255),
quantity text not null,
created DATETIME,
modified DATETIME
)ENGINE=InnoDB DEFAULT CHARSET=latin1;
And this is inside my pils_controller.php:
function newpil() {
$user_id = $this->Session->read('User.id');
$pilid = $this->Pil->find(
array(
'conditions' => array('Pil.user_id' => $user_id),
'fields' => array('Pil.pilid'),
'order' => array('Pil.pilid DESC'),
));
$pilid2 = ($pilid['Pil']['pilid'] + 1);
...
}
What i want is for the above function to pick out the last pil
(product inquiry list) that the user set-up and to add a 1 to that.
Any ideas where im going wrong? Any help will be greatly appreciated.
Thank you
Ste
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
