SQL not returning entire field

From: Date: Thu, 11 Sep 2003 01:06:26 +0000
Subject: SQL not returning entire field
Groups: php.general 
Request: Send a blank email to php-general+get-162162@lists.php.net to get a copy of this message
Please Help! I am using PHP to pull data from a MS SQL database. All other fields are returning data fine, but this one table PROFILE is returning only like some of the data in the field. I am using the following simplified code: MSSQL_CONNECT($HostName,$UserName,$Password); mssql_select_db($DBName) or DIE("Table unavailable"); $ProfileResults = MSSQL_QUERY("SELECT Profile FROM CompanyProfile WHERE CompanyID = '3004'"); $ProfileField = MSSQL_FETCH_ARRAY($ProfileResults); $Profile = wordwrap($ProfileField["Profile"]); echo $Profile; MSSQL_CLOSE(); Actual Field Data "99 Services, Inc. is a full service IT systems integrator and general contractor specializing in cradle to grave technology planning with strong emphasis on LAN/WAN design (routing and switching) and deployment of high speed, fully redundant, high availability networks. 99 Services also provides Internet/Intranet/Website/email systems design. The company services small to medium sized businesses as well as home offices." What I am getting back "99 Services, Inc. is a full service IT systems integrator and general contractor specializing in cradle to grave technology planning with strong emphasis on LAN/WAN design (routing and switching) and deployment of high speed, fully redundant, high availab"

« previous php.general (#162162) next »