query is not working

[derksj]

Does anymone see if there is something wrong with this query

it doesnt give any count result

 $connection = mssql_connect($db_hostname, $db_username, $db_password);
     $db = mssql_select_db($db_name, $connection);
     $sql = "SELECT COUNT(intCv) AS cntCV FROM tbCV";
     $result = mssql_query($sql,$connection);
     $row = mssql_fetch_array($result);
     echo '<P>Totaal aantal inschrijvingen: '.$row['COUNT(cntCV)'].'</P>'; 

[The_Chancer]

Have you tried selecting all rows then mssql_num_rows ?

Also should mssql_fetch_assoc be mssql_fetch_row ? Not 100% but it is a possibility. And doesn't a COUNT require a GROUP BY clause as well ? (can't remember.. LOL)

[rincewind456]

I think you'll find

$row['COUNT(cntCV)']

Should be

$row['cntCV']

[derksj]

thanx that was the problem