hello,
I store in a field of my mysql database a text which looks like this : <title> hello </title> <text> text </text>
In fact I want to generate a xml document using this content.
In a php file, i'm calling my dtd and my xsl files, so as to generate a xml document.
But it doesn't work, as a result I just get the contents of the <title> and <text> tags, of my mysql database.
The code of my php file looks like this :
<?php
echo("
<?xml version='1.0'?>
<!DOCTYPE document SYSTEM 'editorial.dtd'>
<?xml:stylesheet type='text/xsl' href='editorial.xsl'?>
<document>");
$connect=mysql_connect("localhost","","");
mysql_select_db("database",$connect);
$query="select * from editorial";
$result=mysql_query($query,$connect);
while($r=mysql_fetch_array($result))
{
$num=$r[0];
$content=$r[4];
echo("
<article num='$num'>
$content
</article>");
}
echo("</document>");
?>
it works as if it doesn't take my xsl file into account....
Could someone help me, perhaps I'm wrong with my way of generating xml document.
