Depending on the database you are working with (mysql, postgres) you
could read the documentation and look for a function that returns the
last ID
I think it's SELECT LAST_INSERT_ID();
On 10 feb, 18:00, Salam Fall <[EMAIL PROTECTED]> wrote:
> Just solved the problem
> Here is how I have done it
> $ret = $this->Client->query("Select id from clients
> order by id
> DESC LIMIT 1");
> $newid=$ret[0]['clients']['id'] + 1;
> $yr=date("y");
> $account="$branch-$yr-00$newid";
> $this->data['Client']['acct_numb'] = $account;
> $this->Client->create();
> if ($this->Client->save($this->data)) etc....
>
> Now my other question is how do i create my own classes and make them
> available in the controller and the view??
>
> On Feb 9, 5:34 pm, Salam Fall <[EMAIL PROTECTED]> wrote:
>
> > Here is what i have done so far but it's not working
> > $branch="SEN";
>
> > $ret = $this->Client->findBySQL("Select id from
> > clients order by id
> > DESC LIMIT 1");
> > $lastId=$ret[0]['id'];
> > $act=$lastId + 1;
> > $yr=date("y");
> > $account="$branch-$yr-00$act";
> > $this->data['Client']['acct_numb'] =
> > $account;
> > $this->Client->create();
> > if ($this->Client->save($this->data) etc....
>
> > On Feb 9, 5:31 pm, Salam Fall <[EMAIL PROTECTED]> wrote:
>
> > > Nubee here
>
> > > How do I find the last record in the database and have it's ID value
> > > in the controller and be able to manipulate it mathematically.
>
> > > Because all i want to do is put the ID of the last record of the
> > > Clients table add 1 to it and append the result to a string that will
> > > be used to create the Client account number.
>
> > > Also if I want to create my own custom functions or classes to add to
> > > my cake APP how do I do that.
>
> > > Thanks for your help.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
