Anyone know how to do this on DH?
When you click "browse" it defaults to 30 rows. At the top of the rows, you can change the number of results to display.
Or you can click SQL at the top and do something like this...
SELECT * from LIMIT 100
...and that will return 100 rows.
I know, but is there any way to make it show 100 rows by default when I hit browse?
Yes and no.
$cfg['ShowAll'] = FALSE; // allows to display all the rows
$cfg['MaxRows'] = 100; // maximum number of rows to display