note 18317 added to function.mssql-query
| From: | suwalukp at notes dot nectec dot or dot th | 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