[PHP-DB] One query, different tables?
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
[PHP-DB] Re: One query, different tables?
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
Re: [PHP-DB] One query, different tables?
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. This sounds like a database design question more than a PHP one. 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 -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] One query, different tables?
Why do you have to tables with products? Couldn't you have a type or category column and then have to only query one table? Bastien On Fri, Aug 9, 2013 at 11:52 AM, Niel Archer n...@chance.now 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. This sounds like a database design question more than a PHP one. 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 -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Bastien Cat, the other other white meat
Re: [PHP-DB] Re: One query, different tables?
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 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