Re: [PHP] PHP or SQL to do this?

2010-02-23 Thread Jim Lucas
Rob Gould wrote: I'm not sure if I need to write a PHP for-loop to do this, or if it can all be done in one SQL statement? Basically, I want to copy all the barcodes from one table and put them into another table, but only if the barcode in the first table > 0, and only if the wineid's match

[PHP] PHP or SQL to do this?

2010-02-23 Thread Rob Gould
I'm not sure if I need to write a PHP for-loop to do this, or if it can all be done in one SQL statement? Basically, I want to copy all the barcodes from one table and put them into another table, but only if the barcode in the first table > 0, and only if the wineid's match from table to table