still having problems (PHP SQLite)

 
    // grab pertinent records
    $db = sqlite_open($ticketdb) or die ("can not create or read file $ticketdb");
        $r = sqlite_escape_string($r);
 
    if(!isset($u)) {
        $query = "SELECT ticketid, status, severity, priority, madeby, madedate, assignto, described, body
                    FROM tickets ORDER BY madedate DESC LIMIT $r, $hits;";
        }
    else {
            $u = sqlite_escape_string($u);
        $query = "SELECT ticketid, status, severity, priority, madeby, madedate, assignto, described, body
                    FROM tickets WHERE assignto = '$u' ORDER BY madedate DESC LIMIT $r, $hits;";
        }
    $result = sqlite_query($db, $query);
    $arrayTickets = sqlite_fetch_all($result);
    sqlite_close($db);
 
... SNIP PRINT TABLE ...
 
    foreach($arrayTickets as $row)
        {
        $madeby = $row[4];
        $assignto = $row[6];
 
        $dbuser = sqlite_open($chatdb) or die ("can not create or read file $chatdb");
            $madeby = sqlite_escape_string($madeby);
            $query = "SELECT username FROM users WHERE userid='$madeby';";
            $result = sqlite_query($dbuser, $query);
            $array = sqlite_fetch_array($result);
            $madeby = $array[0];
 
            $assignto = sqlite_escape_string($assignto);
            $query = "SELECT username FROM users WHERE userid='$assignto';";
            $result = sqlite_query($dbuser, $query);
            $array = sqlite_fetch_array($result);
            $assignto = $array[0];
        sqlite_close($dbuser);
 
... SNIP PRINT TABLE ...