Getting error using mssql_next_result
| From: | Jim Wentz | Date: | Thu, 09 May 2002 02:26:44 +0000 |
| Subject: | Getting error using mssql_next_result | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19074@lists.php.net to get a copy of this message | ||
In a phpfile, I am using the following:
$link = mssql_connect($dbservername, $dbusername, $dbpassword) or
DIE("DATABASE FAILED TO RESPOND.");
mssql_select_db($dbserverdbnameacct) or DIE("Table unavailable");
$sql = "insert into test (descrip) values ('another test record') select
@@identity";
$result = mssql_query($sql, $link);
$i = mssql_next_result($result);
Inspection of the table test proves that the first of the two sql statements
in $sql is functioning. However, I constantly get the following error:
"Warning: Supplied argument is not a valid MS SQL-result resource in
C:\Inetpub\wwwroot\VisionCall\SubmitLoginRequest.php on line 11"
Any ideas? Any help is greatly appreciated!