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 

> 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 
> wrote:
>
> > 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 truck but can't transfer them back to
> >> store.
> >> I have 4 stores and like to transfer products between this.
> >>
> >> I like to to it like this:
> >> store_one -> truck_document -> store_two
> >>
> >> But how can I transfer both Dynamite and Exan in one query to their
> >> respective tables? (One table is named exan and the other dynamite.)
> >>
> >> Thank you very much for your help.
> >>
> >> I have been searching google but can't find anything about this
> question.
> >>
> >> Karl
> > This makes no sense.  How are we supposed to help you with just this to
> go on?
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


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  wrote:

> 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 truck but can't transfer them back to
>> store.
>> I have 4 stores and like to transfer products between this.
>> 
>> I like to to it like this:
>> store_one -> truck_document -> store_two
>> 
>> But how can I transfer both Dynamite and Exan in one query to their
>> respective tables? (One table is named exan and the other dynamite.)
>> 
>> Thank you very much for your help.
>> 
>> I have been searching google but can't find anything about this question.
>> 
>> Karl
> This makes no sense.  How are we supposed to help you with just this to go on?
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php