PHP and stinking ms again

[pld]

Okay, so I can connect to the ms sql server, but now the problems begin...

for instance, i have a table of user data on the mssql server, so i want to count the total number of rows in the table:

mssql_select_db('[test]', $conn) or die("Couldnt select database users");

$result = mssql_query("SELECT count(*) FROM users WHERE username='pdavid'") or die("Couldn't query the user db.");

ECHO $result;

$num = mssql_result($result, 0) or die("Couldnt get result");

ECHO $num;

Now, as expected, I get a resource ID when I ECHO the $result variable, but for some reason, the $num variable doesnt wanna work. I get an error message:

Warning: Wrong parameter count for mssql_result() in C:\Program Files\Apache Group\Apache2\htdocs\mstest.php on line 17

anyone with any thoughts?

[stolzyboy]

according to the documentation, there are three parameters

string mssql_result ( resource result, int i, mixed field)

[pld]

(smacks forehead)

Had to pass the third parameter as NULL. (And apprently I have to make sure I am looking at the mssql_result documentation instead of the mysql_result documentation...)

Thanks for being patient with that stupid question.

[stolzyboy]

no problem, don't smack your forehead too hard all the ones and zeros will fall out of your brain, then your really screwed