note 18316 rejected from ref.mssql by irc-html

From: Date: Fri, 18 Jan 2002 14:12:22 +0000
Subject: note 18316 rejected from ref.mssql by irc-html
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-25033@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

« previous php.notes (#25033) next »