Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

[PHP-DB] Access Violation at 00030003 From: shawn blue (shawnblue <email protected>)
Date: 12/13/00

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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>