Linked tables

Hi everyone.

I have an interesting problem. We have two PHP shops that use MySQL
databases. The database structures are exactly he same. Due to the two
companies now working together we want the products to be the same on
both, but not the customers or the looks of the shops (both shops are
oscommerce). what we really want to do is in the mysql database remove
the products/categories/manufacturers tables and link them to another
database. Is this possible in MySQL without rewriting all the PHP?

All we want is linked tables like you can have in Access, not linked
tables in the PHP as to rewrite the PHP is rather a major job!

re: Linked tables

Dave wrote:[color=blue]
> All we want is linked tables like you can have in Access, not linked
> tables in the PHP as to rewrite the PHP is rather a major job![/color]

Have you read about MERGE tables? That feature might do what you want.

http://dev.mysql.com/doc/mysql/en/ME...ge_engine.html

Regards,
Bill K.

re: Linked tables

Cool! thanks for that, it does very nearly what i want, but i have
managed to botch it so that it does exactly what i want.

Thanks for the help!

Bill Karwin <bill@karwin.com> wrote in message news:<coiafb01hrk@enews4.newsguy.com>...[color=blue]
> Dave wrote:[color=green]
> > All we want is linked tables like you can have in Access, not linked
> > tables in the PHP as to rewrite the PHP is rather a major job![/color]
>
> Have you read about MERGE tables? That feature might do what you want.
>
> http://dev.mysql.com/doc/mysql/en/ME...ge_engine.html
>
> Regards,
> Bill K.[/color]