<?xml version="1.0"?>
<?xml-stylesheet href="rooster.xsl" type="text/xsl"?>
<?cocoon-process type="xslt"?>

<?php
    Include("db.php");
    $dbcart = new db;
    $dbcart->init("odbc");
    $dbcart->open("rooster","localhost","","");
    $query="SELECT *
            FROM Rooster;
    $dbcart->query($query);
?>

<programma>
<?php
    while($dbcart->getrow()) {
      $ps = $dbcart->field(1);
      $datum  = $dbcart->field(2);
      $sport1  = $dbcart->field(3);
      $sport2 = $dbcart->field(4);
?>
	<dag>
	<ps><?php echo $ps; ?></ps>
    	<datum><?php echo $datum; ?></datum>
    	<sport1><?php echo $sport1; ?></sport1>
    	<sport2><?php echo $sport2; ?></sport2>
  	</dag>
<?php
	}
	$dbcart->close();
?>
</programma>
