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