<?
 
$dbhost = 'localhost';
$dbusername = 'xylude';
$dbpassword = '';
$database_name = 'allprodata';
 
 
$connection = mysql_pconnect("$dbhost", "$dbusername", "$dbpassword")
	or die ("Could not connect to database");
 
$db = mysql_select_db("$database_name", $connection)
	or die ("Could not find database");
 
 
 
 
 
	$returnstrings = mysql_query("SELECT * FROM videos WHERE category = 'dice'") 	
		or die(mysql_error());
 
 
		$rowcount = 0;
 
 
		echo "  <table width='200' border='1'>";
				while ($result = mysql_fetch_assoc($returnstrings))
{
			$rowcount = $rowcount + 1;
 
 
			$thumbnail = $result ['vidthumbsrc'];
			$hlink = $result ['previewurl'];
			echo "<td align = 'center'><img src = '$thumbnail'><br>";
			echo "<a href = '$hlink'>";
			echo $result ['name'];
			echo "</a></td>";
			if ($rowcount == 4)
			{
			echo "</tr>";
			echo "<tr>";
			$rowcount = 0;
			}
}
 
	echo mysql_num_rows($returnstrings);
 
?>