[ic] Displaying number of rows in a table

[Interchange User]

Hello,

I would like to access the number of items in a SQL table.  I haven't  
had much luck getting at the results using SQL, and I'm wondering if  
there's a simple way to access mv_return_fields after pointing a  
[search] tag at one of the tables, or if it's easier to use the [query]  
tag.

	I know I'm doing something wrong , but this is what I've been trying:
------------------------------------------------------------------------ 
-----
[query
	sql="select count(*) as requestcount from www_mediarequest"
	type=list
	list=1
	st=db
	]
	[list]
		[sql-param requestcount]
	[/list]
[/query]
------------------------------------------------------------------------ 
-----
IC 4.9.8 nightly
MySQL 4.1 alpha

Thanks,

Peter