aantalperpagina; $check = "SELECT * FROM filmvandedag WHERE datum = '$date2' ORDER by id DESC"; $querycheck = mysql_query($check) or die (mysql_error()); $aantal2 = mysql_num_rows($querycheck); if($aantal2 != "0") { $q3=mysql_fetch_object($querycheck); $finaalid = $q3->id; $dataq=mysql_query("SELECT * FROM movies WHERE Activeren = 1 AND id= '$finaalid'"); $q=mysql_fetch_object($dataq); } else { $dataq=mysql_query("SELECT * FROM movies WHERE Activeren = 1 ORDER BY RAND()"); $q=mysql_fetch_object($dataq); $finaalid = $q->id; $sql = "INSERT INTO filmvandedag (datum, id) VALUES ('$date2', '$finaalid')"; mysql_query($sql) or die("error ".mysql_error()); } $l++; $Huidig2 = mysql_fetch_object(mysql_query("SELECT * FROM Rating WHERE ID = '$finaalid'")); $Stemmen2 = explode("|",$Huidig2->Stemmen); $Afronden = 2; $gem = round(array_sum($Stemmen2)/count($Stemmen2),$Afronden); $aantalstemmen = count($Stemmen2); $querybekeken = "UPDATE movies SET bekeken = bekeken+1 WHERE id = '$finaalid' LIMIT 1"; mysql_query($querybekeken); print("document.write('

');\n"); print("document.write('

Filmpje van de dag van Filmpjes.webmention.com

');\n"); print("document.write('".$q->titel."
');\n"); if($q->soort == "youtube") { print("document.write('

');\n"); } if($q->soort == "garagetv") { print("document.write('". $q->volledig."');\n"); } print("document.write('

Aantal keer bekeken: ".$q->bekeken."
');\n"); print("document.write('

Ingezonden door: ".$q->door."
');\n"); $string = $q->toegevoegd; $patterns[0] = '/ /'; $replacements[1] = ' om '; $toegevoegd = preg_replace($patterns, $replacements, $string); print("document.write('

Toegevoegd op ".$toegevoegd."

');\n"); //$ID = $q->id; include("rating.php"); print("document.write('

');\n"); print("document.write('

');\n"); ?>