multiple sql queries

<?php
/* Snippet name: CurrentNewsletter
 * Author: Sarah Vardy
 * Release date: 15th November, 2007
 * Description: This snippet shows the articles in the current newsletter. Works with MakeNewsletter and PostNewsletter
 * 
 * Still in development!!!
*/

//initialize counter to zero
$counter = 0;

//make connection to the rcs_it_newsletters table
$table = $modx->getFullTableName("rcs_it_newsletters");

//query to rcs_it_newsletters table
$query = "SELECT * FROM $table";

$doQuery= $modx->db->query($query);

$numrows=mysql_num_rows($doQuery);

if($numrows>0)
{
 while($doc_ids=mysql_fetch_array($doQuery))
  {
  $doc_ids=unserialize($doc_ids['doc_ids']);  
  $doc_weights=unserialize($doc_weights['doc_weights']);
  }
}

print 'Got here!';
//connection to site_content database
$table_content = $modx->getFullTableName("site_content");

//fields to query the database with
$fields=('id,pagetitle,createdby,createdon');

//test each id in the database and find the id number of the document and the matching row information in the database
$sql= "SELECT {$fields} FROM {$table_content} table_content  WHERE table_content.parent= '48' AND table_content.published = '1' ORDER BY table_content.createdon DESC LIMIT 3";

$results= $modx->db->query($sql);


/*while ($row = $modx->db->getRow($results)) {
}
    store the id in an array
    $id[$counter] = $row[id];
    print $id[$counter];
    store the title in an array
    $title[$counter] = $row[pagetitle];
    store createdby in an array
    $createdby[$counter] = $row[createdby];
    store createdon in an array
    $createdon[$counter] = $row[createdon];
    print $counter;
    $counter++;
    
}
*/


// compare the results in the arrays 
/*
for ($i = 0; $i<count($id); $i++)
{
    // if the id stored in the doc_ids array matches the id stored in the id array
    if ($id[$i] != $doc_ids[$i])
    {
         
        print 'NO MATCH!';
    }
    else
    {
        print 'FOUND A MATCH!';
    }
}
*/
?>

 while($doc_ids=mysql_fetch_array($doQuery))
  {
  $doc_ids=unserialize($doc_ids['doc_ids']);  
  $doc_weights=unserialize($doc_weights['doc_weights']);
  }