Re: 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 <[email protected]> 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