Database search only returning 1 search result

I have made a film database app where a user can search for a film, which then displays the search results in a scrollView. However whenever I search for a string that should bring back multiple films like "the", it will only return the first result it sees. Any idea why?

MainActivity:

public void search(View v){
    EditText search = (EditText)findViewById(R.id.edtSearch);
    String searchresult = "%" + search.getText().toString() + "%";
    db = new DbHelper(this).getReadableDatabase();
    String[] column = {"*"};
    String where = "film LIKE ? OR actor LIKE ? OR actor2 LIKE ? OR director LIKE ?";
    String[] selArgs = {searchresult, searchresult, searchresult, searchresult};
    Cursor results = db.query("FILMTABLE", column, where, selArgs, null, null, null);
    film(results);
}

public void film (Cursor c) {

        c.moveToFirst();
        int filmint = c.getColumnIndex("film");
        int id = c.getColumnIndex("id");
        String film = c.getString(filmint);
        int filmID = c.getInt(id);

        TextView txt = new TextView(getApplicationContext());
        txt.setId(filmID);
        txt.setText(film);
        txt.setTextColor(Color.BLACK);
        txt.setTextSize(16);
        txt.setClickable(true);
        txt.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent intent = new Intent(getApplicationContext(), MainActivity4.class);
                intent.putExtra(FILM_ID_KEY, String.valueOf(v.getId()));
                startActivity(intent);
            }
        });

        ScrollView scrollView = (ScrollView) findViewById(R.id.scrollView);
        scrollView.addView(txt);

    }