this is my php-code...
<?
header("Content-type: text/xml");
include "../include/dbconn.inc";
$sql1 = " SELECT TABLE_NAME, ";
$sql1.= " TABLE_KOR_NAME, ";
$sql1.= " CREATOR ";
$sql1.= " FROM kli.TMZTABLE ";
$sql1.= " WHERE TABLE_NAME like 'tmc%' ";
$sql1.= " order by TABLE_NAME ";
$result1 = sybase_query($sql1, $dbconn);
$rows1 = sybase_num_rows($result1);
if($rows1==0){
echo('error');echo('****'.$rows1.'#####');
}
else{
echo("<?xml version=\"1.0\"?>\n<?xml:stylesheet type=\"text/xsl\" href=\"test_xml.xsl\"?>\n<table_list>");
for($row_index = 0; $row_index < $rows1 ; $row_index++){
$d_table_name = sybase_result($result1,$row_index,0);
$d_table_kor_name = sybase_result($result1,$row_index,1);
$d_creator = sybase_result($result1,$row_index,2);
?>
<title_1>
<table_name><?echo($d_table_name);?></table_name>
<table_kor_name><?echo($d_table_name);?></table_kor_name>
<creator><?echo($d_creator);?></creator>
</title_1>
<?
}
?>
</table_list>
<?
}
sybase_free_result($result1);
sybase_close($dbconn);
?>
and this is my xsl-code
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:template match="/">
<xsl:apply-templates select="//title_1" />
</xsl:template>
</xsl:stylesheet>
..............
browser shows nothing...
pls, help me...
what's wrong with this codes....
thanks in advance....