How do I combine two recordsets into one in Dreamweaver? (MX2004) I am using PHP and MYSQL.
Explanation: This is an events page. I have two recordsets, each one is pulling information from two identical tables located in separate databases (different connections), combining the data to produce one output of a complete list.
I have read up on the JOIN and UNION statements, just not sure exactly how to implement or what the syntax would be to implement this. I am assuming I need a third recordset to combine the two.
Can anyone enlighten me?