note 18317 added to function.mssql-query

From: Date: Fri, 18 Jan 2002 10:08:32 +0000
Subject: note 18317 added to function.mssql-query
Groups: php.notes 
Request: Send a blank email to php-notes+get-25019@lists.php.net to get a copy of this message
I created a varchar field in SQL Server 2000 that has size 6000 chars. When I query from Query Analyser, the result on the display from this analyzer is complete with 6000 chars. However, when I query via PHP by command mssql_query, the result displayed is only the first 255 chars and the rest is gone... Here is the code from which I got the result 255 chars. <? $query = "select f1 from test"; $result = mssql_query($query); while ($row = mssql_fetch_array($result)){ $author = $row["f1"]; echo $author; } ?> ...Can anyone tell me what is wrong with this query? and how can I get 6000 chars full, not just 255 chars? Thanks, Apple -- http://www.php.net/manual/en/function.mssql-query.php http://master.php.net/manage/user-notes.php?action=edit+18317 http://master.php.net/manage/user-notes.php?action=delete+18317 http://master.php.net/manage/user-notes.php?action=reject+18317

« previous php.notes (#25019) next »