Weblabor

<script src="playerMini/swfobject.js" type="text/javascript"></script>

<?php

include('database.php');
$ab = new Adatbazis();

if ($ab->connect()) {
	//echo "Connected<br />";
} else {
	echo "Not Connected<br />";
}
if ($ab->selectDatabase('sch')) {
	//echo "Database Selected<br />";
} else {
	echo "Database Selection Problem getcontent<br />";
}
$query = "SELECT title, link, date FROM mixes ";
$res = $ab->command($query);

		if (!$res) { 
					echo "command error<br />";
		}
		else{
		
		while($row = mysql_fetch_array($res))
		{	
			echo '<div class="mixout">';
			echo "<h1>".$row['title']."</h1>";
			echo "<h2>Uploadad on".$row['date']."<h2> ";
			echo "<a href=".$row['link'].">Download</a>";
			echo '<div id="flashPlayer">';
			echo 'This text will be replaced by the flash music player.';
			echo '</div>';

		   echo '<script type="text/javascript">';
		   echo 'var so = new SWFObject("playerMini/playerMini.swf", "mymovie", "75", "30", "7", "#FFFFFF");';
		   echo	' so.addVariable("autoPlay", "no");';
		   echo	'  so.addVariable("soundPath", "'.$row['link'].'");';
		   echo	' so.write("flashPlayer");';
		   echo  '</script>';
		   echo "</div>";
			
		}
		
		}

$ab->disconnect();

?>