I am just wondering if there is a way to store data from two different mySQL tables in a single recordset. If this is possible it would be great to be pointed in the right direction. The reason is that I have an old version of a table and a new version of a table (with different fields) and I want to be able to search both of them at the same time.
It´s possible by joining the tables in question, example explained here: http://www.tizag.com/mysqlTutorial/mysqljoins.php
Other than that you´ll find lots of additional tutorials when googling for "php mysql query multiple tables".
in the future better post such question in the regular Dreamweaver Application Development forum. The current forum deals with questions which are related to the Dreamweaver extension ADDT, which generates proprietary PHP code and has been discontinued over a year ago, that is, the number of fellow forum participants is much larger in the regular Dreamweaver forums.