Hvad er der galt her...... ????
<?header("Content-Type: text/xml");
require '../subpages/mysqlfunctions.php'; //importér mysqlfunctions halt on error.
$connection = openMysql("localhost", "encory", "ghost21", "encdab");
$xmlversion = "1.0"; //Definér hvilken Xml version du ønsker at bruge
$contenttypecss = "text/css";
$contenttypexsl = "text/xsl";
$encoding = "iso-8859-1"; //valg af tegntabel
$table ="scripts"; //Rod element navn samt navn på tabellen i databasen
$query = "SELECT * FROM $table"; //Select sætningen. Sqlquery
$xslStyleSheet =""; //Sti og filnavn til xsl-stylesheet
$Css = ""; //Sti og filnavn til CSS-stylesheet
$Dtd = ""; //Sti og filnavn til validerings DTD
$qmark = "?"; // Laver et ? for at undgå at bruge ? > tegnet i XML deklareringen
$endtag = ">"; // Laver et > for at undgå at bruge ? > tegnet i XML deklareringen
$sgn = '"'; //laver " kolon tegn
if ($query) {
$result = mysql_query($query) or die(mysql_error());
$num_fields = mysql_num_fields($result);
$num_rows = mysql_num_rows($result);
print "<?xml version=$sgn$xmlversion$sgn encoding=$sgn$encoding$sgn$qmark$endtag\n";
if ($Dtd) {
print "<!DOCTYPE scripts SYSTEM $sgn$Dtd$sgn>\n";
else {
print "<!--DOCTYPE scripts SYSTEM $sgn$Dtd$sgn-->\n";
}
if ($Css) {
print "<?xml-stylesheet type=$sgn$contenttypecss$sgn href=$sgn$Css$sgn$qmark$endtag\n";
}
else {
print "<!--?xml-stylesheet type=$sgn$contenttypecss$sgn href=$sgn$Css$sgn$qmark$endtag-->\n";
}
if($xslStyleSheet) {
print "<?xml-stylesheet type= $sgn$contenttypexsl$sgn href=$sgn$xslStyleSheet$sgn$qmark$endtag\n";
}
else {
print "<!--?xml-stylesheet type=$sgn$contenttypexsl$sgn href=$sgn$xslStyleSheet$sgn$qmark$endtag-->\n";
}
print "\n";
print "<$table>\n";
for ($j=0;$j<$num_rows;$j++) {
$row = mysql_fetch_array($result);
$idnr = $row["IdNr"];
$type = $row["Type"];
print " <script id='$idnr' type='$type'>\n";
for ($i=0;$i<$num_fields;$i++) {
$field_name = mysql_field_name($result,$i);
print "<$field_name>";
print "$row[$i]";
print "</$field_name>\n";
}
print " </script>\n";
}
}
print "</$table>";
?>
Dette giver under runtime følgende fejl i MSIE 6.0.
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------------------------------------------------------------
The following tags were not closed: br, br. Error processing resource 'http://www.encory.dk/xml/sql2xml.php'.
