I have a MySQL server running PHP4. We aer working on migrating many of our systems ontop this new platform. In order to help with database maintenance, we have created a separate 'lookups' database, which contains tables which are used as lookups to a number of different databases.

However, I am having difficulty understanding how to query two databases simultaneously using Dreamweaver. For example, I have an employees table which stores a value for the persons title(i.e. 1 = 'Mr'). The description associated with the value is stored in the lookup database.

Has anyone got any ideas?

Maybe try setting up multiple <i>Connections</i>, other than that I wouldn't think DW can handle multiple DB's, but mutiple Tables isn't a problem for DW.

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>