Getting Relevant Info from 2 Queries

[obrienkev]

Hi all,
I have two databases - they are linked by field called ffnumber.

My second query wants to return FirstName and SurName where ffnumber is equal to ffnumber of the first query.
How do I get this to work??

Thanks.

MSSQL Server Query:

// Perform Query
$query = "SELECT * ".
               "FROM class AS cl ".
                 "INNER JOIN ".
                 "course AS c ".
                 "ON cl.course_ID = c.course_ID ".
                 "inner join training as tr on tr.class_ID = cl.class_ID ".
                 "WHERE cl.course_ID = '$course' ".
                 "ORDER BY cl.class_date ".
                 "DESC";
$result = mssql_query($query) or die('Select Query Error');

$items = array();

while ($row = mssql_fetch_assoc($result))
{
$items[] = $row;
}

MySQL Query:

/***********************
Get Staff Details
***********************/
include('../staff_db_connect.php');

// Perform query
$queryz = "SELECT FirstName, SurName ".
            "FROM EMPLOYEES_Registered ".
              "WHERE FFNumber = '$ffnumber' ".
              "ORDER BY SurName";
$resultz = mysql_query($queryz) or die(mysql_error());
while($rowz = mysql_fetch_array($resultz))
{
     // set name variables
        $firstname = $rowz['FirstName'];
        $surname = $rowz['SurName'];
//echo $surname;
}

[laserlight]

I have two databases - they are linked by field called ffnumber.

You are trying to use the results from a MySQL database in a MSSQL database?

My second query wants to return FirstName and SurName where ffnumber is equal to ffnumber of the first query.

If you are working with different database systems, then just get one to return the results in an array. After that solve the problem using that array, instead of thinking of two queries.

[obrienkev]

Hi can you show me a code example please?

Thanks.

[laserlight]

I dont think an example is needed here. It is basically what you've been doing all along, except that instead of printing what you get from the query, you now plug it into another query.