Vill du visa hur stor chans det var att just det klippet blev visat?
Isåfall:
PHP-kod:
<?php
$dbconnection = mysql_connect("localhost", "root", "");
mysql_select_db("youtube", $dbconnection);
$query = mysql_query("Select * from youtube order by rand() limit 1");
$num = mysql_query("SELECT COUNT(id) AS count FROM youtube") or die(mysql_error());
while ($row = mysql_fetch_array($query)) {
echo '<object width="420" height="315"><param name="movie" value="http://www.youtube.com/v/' . $row['url'] . '" /><param name="allowFullScreen" value="true" /><param name="allowscriptaccess" value="always" /> <embed type="application/x-shockwave-flash" width="420" height="315" src="http://www.youtube.com/v/' . $row['url'] . '" allowfullscreen="true" allowscriptaccess="always"></embed></object>';
}
echo '<br />Chansen att just detta videoklipp blev visat är <b>' . round(1 / mysql_result($num, 0, 'count'), 2) . '%</b>';
?>