$database->addNewUser($subuser, md5($subpass), $subulevel, $subemail);
       
       if(isset($subuser)) {
       
          $user_id = mysql_insert_id();
       
          $database->addNewBroker($user_id, $subname, $subaddress, $subcity, $substate, $subzip, $subcontact, $subphone, $subfax);
          
          return 0;  //New user added succesfully
       }
       else{
          return 2;
       } 

function addNewUser($username, $password, $userlevel, $email){
      $time = time();
      $q = "INSERT INTO ".TBL_USERS." VALUES ('$username', '$password', 0, '$userlevel', '$email', $time)";
      return mysql_query($q, $this->connection);
   }
   function addNewBroker($user_id, $name, $address, $city, $state, $zip, $contact, $phone, $fax){
      $q = "INSERT INTO tbl VALUES ('$user_id', '$name', '$address', '$city', '$state', '$zip', '$contact', '$phone', '$fax')";
      return mysql_query($q, $this->connection);
   } 

<?php

$sql = "SELECT * FROM `some_table` WHERE `something`=99";
if( $result=@mysql_unbuffered_query($sql, $conn) )
{
  // do something with the row.
}
else
{
  trigger_error( $sql."\n".mysql_errno($conn)." - ".mysql_error($conn), E_USER_ERROR );
}