Re: [PHP-DB] Re: One query, different tables?

2013-08-10 Thread Jorge
As someone else say, is problem of DB design, probably you can do all the necessary queries in only one transaction. Un saludo, Jorge. 2013/8/9 Karl DeSaulniers k...@designdrumm.com Probably with separate queries I would say. Query store 1, move to truck then query truck and move to store 2.

[PHP-DB] Re: One query, different tables?

2013-08-09 Thread Jim Giner
On 8/9/2013 10:56 AM, Karl-Arne Gjersøyen wrote: Hello. I am newbie in this and need som basic help. I have a form witch checkbox'es with different serialnumbers. The serialnumbers reflect different products and every product category have their own tables. I can transfer items from store to

Re: [PHP-DB] Re: One query, different tables?

2013-08-09 Thread Karl DeSaulniers
Probably with separate queries I would say. Query store 1, move to truck then query truck and move to store 2. Best, Karl Sent from losPhone On Aug 9, 2013, at 10:13 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 8/9/2013 10:56 AM, Karl-Arne Gjersøyen wrote: Hello. I am newbie in