count(...) does not exist error

[Kerry Frater]

Hi all,
I am using WAMP on my laptop to test my website (in PHP) and wanted to carry out an SQL statement which also provides a count of child records. I am using dreamweaver CS5.5 to build my site and modify the code as I need to.

The query produces the error

"FUNCTION uc.count does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual"

Googling the error refers to extra spaces but there are no spaces. Can anyone help please?

The query built in sprintf is:

$query_rsCount = sprintf("SELECT uc.count(userid), u.*,g.description as tgender FROM users as u, selgender as g, users_child as uc WHERE venue_id = %s and u.oidgender = g.oid and u.userid=uc.userid", GetSQLValueString($colname_rsCount, "int"));

$query_limit_rsCount = sprintf("%s LIMIT %d, %d", $query_rsCount, $startRow_rsCount, $maxRows_rsCount);