[Keith]

This is my query

$boatbrands=$DB_site->query('select count(*)
AS countboats, field6 as boatbrands FROM userfield 
WHERE field6 <> "n/a" AND field6 <> "n" AND field6 <> "none" 
AND field6 <> "NA"
GROUP by field6
ORDER BY 1 DESC LIMIT 10');

Now how to display the results of this query? I've added an eval dooutput to a template at the bottom, but the results are showing up as the word "Array" when I use "query_first, and "resource ID #38" when I use "query". I don't think I'm supposed to use query_first because that will only return the first row.

The result is supposed to be 10 rows of 2 columns worth of data, but I can't figure out what I'm doing wrong here.