Re: [fw-db] How do I a row to the same table? or duplicate a set of row based on a criteria

Thanks a lot I will try this, but how about if I wanted to select a set of
rows that matched one criteria and copy them to the same table, how would I
go about achieving that?

Nikos Dimopoulos wrote:
>
> You can try this:
> // Create the new object
> $invoice = new Invoice();
>
> // Get the data from the database - source row
> // You can create the data array yourself if you already have the data
> $invoiceRow = $invoice->fetchRow($invoice->select()->where('invoice_id =
> ?',
> 1));
>
> // Convert the data to an array
> $data = $invoiceRow->toArray();
>
> // Unset the invoice_id which should be the primary key. This will allow
> the
> addition
> // of the new row and the RDBMS will generate a new ID for the new row
> unset($data('invoice_id');
>
> // Create a new row in the table
> $newInvoice = $invoice->createRow($data);
>
> // Save the data
> $newInvoice->save();
>
>
> I hope this helps
>
> Nikolaos
>
> On Fri, Dec 5, 2008 at 01:07, SalamFall <salam@seneweb.com> wrote:
>
>>
>> How do I a row to the same table? or duplicate a set of row based on a
>> criteria?
>>
>> for example:
>> $invoice = new Invoice(); // where invoice is a table Model
>> $invoice_id = $invoice->insert($data);
>> --
>> View this message in context:
>> http://www.nabble.com/How-do-I-a-row-to-the-same-table--or-duplicate-a-set-of-row-based-on-a-criteria-tp20848299p20848299.html
>> Sent from the Zend DB mailing list archive at Nabble.com.
>>
>>
>
>
> --
> The contents of this message may contain confidential or privileged
> information and is intended solely for the recipient(s). Use or
> distribution
> to and by any other party is not authorized. If you are not the intended
> recipient, copying, distribution or use of the contents of this
> information
> is prohibited.
>
>

--
View this message in context: http://www.nabble.com/How-do-I-copy-a-row-to-the-same-table--or-duplicate-a-set-of-row-based-on-a-criteria-tp20848299p20863252.html
Sent from the Zend DB mailing list archive at Nabble.com.