리눅스+php에서 원격의 mssql서버와의 연동
test.php의 내용..
<? include "EnDefinition/ConnectINFO_kmall.inc";
echo("<table border=1>");
$query = "select * from Category" ;
$query_result = mssql_query($query) ;
$number_rows = mssql_num_rows($query_result) ;
$number_fields = mssql_num_fields($query_result) ;
// DISPLAY INDIVIDUAL ROWS - POPULATING THE TABLE
for ($row_number=0; $row_number<=$number_rows-1; $row_number++)
{
print "<tr><td>$row_number</td>";
for ($field_number=0; $field_number<=$number_fields-1; $field_number++)
{
print "<td>" . mssql_result($query_result, $row_number, $field_number) . "</td>" ;
}
print "</tr>" ;
}
print "</table>" ;
mssql_close($connection);
?>
실행 하면 아래와 같은 에라가... 고수님들의 조원좀 부탁 합니다..
Warning: Sybase error: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query. (severity 16) in /home/plus/public_html/left.html on line 59
|