Here is your problem:
below is your code:
<snip>
$result = mssql_query($query,$link); file://JUST CRASHES ON THIS LINE
$r = mssql_rows_affected ( $link);
</snip>
The 2nd line there:
$r = mssql_rows_affected( $link );
should be
$r = mssql_rows_affected( $result );
AND, you do not need to pass the $link into the mssql_query($query) function
at that point. It's understood.
Hope that helped ! :)
If you get an error occurred on such and such line, it isn't always
necessary the correct line. It may be the line before, or even multiple
lines before.
Good luck,
--
Nicole Amashta
Web Application Developer
www.aeontrek.com
"Rob Fraser" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
...
Dear All,
I hope somebody can help me. I am new to PHP (I've used ASP for three
years:-( ) and I'm loving PHP and trying to get my work to convert but
I've coming across a error with mssql_query() explorer its just crashes
with a php.exe 'memory could not be read error'. I'm sure it a school
boy error from me but I'm just stuck, please help me code is......
===========
$link = mssql_connect ("laptop", "sa", "elmwood");
print ("<br>LINK was $link");
$back = mssql_select_db ( "elmback",$link);
print("<br>back was $back");
$query = "SELECT * FROM tblperson";
print("<br>query was $query");
$result = mssql_query($query,$link); file://JUST CRASHES ON THIS LINE
$r = mssql_rows_affected ( $link);
print("<br>rows affected was $r");
$close = mssql_close ($link);
print("<br>close was $close");
=========
I run IIS4, NT4 (SP6a) and SQL 7 on the same machine as its my
development one, out of date maybe but you should see my clothes but PHP
was test downloaded a month ago - any ideas from a white knight?
best regards
Rob
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
