Display MySQL Query result

[Keith]

Forgot to say "thanks for the reply" in my other message. Here''s the whole piece which may help.

// ############     How many of each brand of boats

$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');

while($boatbrand=$DB_site->fetch_array($boatbrands)) {
	$boatbrands=$boatbrands["boatbrands"];

}


eval("dooutput(\"".gettemplate("boatstats_stats")."\");");

}

The template has the variable $boatbrands