SQL not returning entire field
| From: | Christopher J. Crane | 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"