Pass the id in a hidden field on your form. Then instead of creating
a new record, it will just update the old record with new information.
On Aug 23, 3:20 am, Unite <[EMAIL PROTECTED]> wrote:
> Hi.
> Heres the problem. I have a form which returns values and stores them
> in a database. When a person presses submit on the form I want the ID
> to stay the same but the rest of the data in the table to be replaced.
> What it is doing at the current moment is only replacing the data that
> has changed. I dont want this. What i want to do is blank all fields
> in the table then add the new data. Heres the code and will give you a
> better idea of what im trying to do.
>
> Notes
> id is of type integer and is the primary key and set to
> auto_increment.
>
> $databaseData = $this->Template->query("SELECT * FROM templates WHERE
> sender_id = ".$sender_id);
>
> if(!empty($this->data)) {
>
> $this->data['template']['sender_id'] = $sender_id;
> //putting
> sender_id into the array
>
> if(empty($databaseData)) {
> $this->Template->id=null; //no template table
> for this sender so
> create 1
> $this->Template->save($this->data); //save
> the data (this part
> works 100%)
> } else {
>
> $this->Template->del($databaseData[0]['templates']['id']); //
> delete that row to make it "blank/empty"
>
> $this->Template->id=$databaseData[0]['templates']['id']; //Go to
> that ID that was deleted
> $this->Template->save($this->data); // Save
> the data to the row
> with the id that was deleted
> }
>
> }
>
> what it does is it keeps increasing the id instead of using the old
> one. This happens due to auto_increment pointer .
> Is there any way to bypass this like delete data from the row except
> the id? Any help would be greatly appreciated.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
