I wrote a simple script to return data from a query. The database is MS SQL
and the field I am looking to return is a VARCHAR(5000). Everything seems to
work except the data returned is not the whole field it is shortened. It
only returns a portion of the field.
Here is the field:
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.
Here is what is returned by the PHP:
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
Here is the script:
<?PHP
/* CTC Profile about Company */
/* ========================= */
$HostName = "DAS54-DAL-SBC";
$UserName = "*******"; //changed for security
$Password = "********"; //changed for security
$DBName = "DirectoryDB";
MSSQL_CONNECT($HostName,$UserName,$Password);
mssql_select_db($DBName) or DIE("Table unavailable");
$ProfileResults = MSSQL_QUERY("SELECT * FROM CompanyProfile WHERE
CompanyID = '$ID'");
$RowCount = MSSQL_NUM_ROWS($ProfileResults);
if($RowCount != 0) {
for ($i = 0; $Field2 = MSSQL_FETCH_ARRAY($ProfileResults); ++$i) {
$Profile = $Field2["Profile"];
echo $Field2["CompanyID"] . "<br>" . $Field2["Profile"] .
"<br><br>To read more information about this ";
echo "company, visit their website\n";
}
}
else { print "This company, $sym is not listed in the CTC Directory."; }
MSSQL_CLOSE();
?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
