Access Violation at 00030003
| From: | shawn blue | Date: | Wed, 13 Dec 2000 15:16:37 +0000 |
| Subject: | Access Violation at 00030003 | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-5212@lists.php.net to get a copy of this message | ||
i have a project that i wrote in php 3.12 and i am moving it to a new server running 4.0.3pl1... it is running on winNT 4.0 iis mssql
and everytime i go to access the db and run mssql_fetch_row it gives me
"PHP has encountered an Access Violation at 0000003A" however i know it is talking to the db because when i just run a
mssql_num_rows it will return the right number for the query???
i dont get it is php 4.0.3pl1 not support mssql_fetch_object?
here is a sample?
<?
require("dbconnect.php3");
$SQL = "SELECT * FROM users where username = 'foo'";
$query = mssql_query($SQL, $connection);
$row = mssql_fetch_object($query);
//WHEN I TRY TO ECHO OUT THE FETCH OBJECT IT CRASHES IF I
//COMMENT IT OUT I WILL SHOW THE RIGHT HUM ROWS?
-> echo "$row->username"; //this does not work
$numrows = mssql_num_rows($query);
-> echo "$numrows"; //but this does?
//CAN ANY ONE HELP ME OUT
?>
i am thinking i messed up the install or something?
the phpinfo page can be found here
http://146.145.141.251/index.php
the numrows page can be found here
http://146.145.141.251/numrows.php
the fetch object can be here
http://146.145.141.251/test.php
thanks
a ton
shawn
_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com