$user "; } die; } ?> DVD-lista / <? echo $omistaja ?> "; } else { echo " "; } if($headline) { echo "

$headline

"; } else { echo " "; } ?>
Listing "; if(isset($_POST[format])) { $format=$_POST[format]; } if(is_array($format)) { foreach($format as $key) { echo "$key, "; } } else { echo 'all'; } print " sorted by "; if(isset($_POST[order])) { $order=$_POST[order]; } if($order=="") { $order="name"; } if($order!="name" && $order!="rating" && $order!="runtime" && $order!="leih") { $sortcolumn=$order; } foreach($tbl_head as $key => $value) { if($value==$order) { print "$key"; } } echo '

'; if($static!="1") { print "

[$laAd]

"; echo "

List "; foreach($format_arr as $key) { echo "$key\n"; } echo '

Sort by '; foreach($tbl_head as $key => $value) { echo "$key\n"; } echo ""; echo ""; echo '

'; } } else { // esivalinta = dvd + hd dvd $format[]='DVD'; $format[]='HD DVD'; } ?> $value) { print ""; } if(isset($_POST[sortcolumn])) { print "\n"; } ?> 0) { $seriestitles++; $seriesdiscs += $Discs; $seriesruntime += $Runtime = mysql_result($dbquery, $x, "Runtime"); } else { $featdiscs += $Discs; $Runtime = mysql_result($dbquery, $x, "Runtime"); } $Name = str_replace(" - ", " – ", $Name); $tausta=$tbcolor2; switch($Rating) { case 1: $tausta="red"; break; case 2: $tausta="yellow"; break; case 5: $tausta="lightgreen"; break; default: $tausta=$tbcolor2; } echo "\n"; $years[$Jahr]++; $totalruntime+=$Runtime; echo "\n"; $regions[$Region]++; $totaldiscs+=$Discs; $formats[$Type]++; echo "\n"; echo "\n"; echo ""; echo ""; $num_rows++; if(isset($sortcolumn)) { print "\n"; } echo "\n"; } // END FOR echo "
$key $sortcolumn   
$Name ($Jahr)$Runtime min ($Discs × $Region$Type)$Director"; $ratings[$Rating]++; for($counter=0;$counter<$Rating;$counter++) { echo '€ '; } if($Rating=="0") { echo "$laNotrated"; } echo "   $Leih"; switch($sortcolumn) { case "aspect": echo "$Aspect"; break; case "director": echo "$Director"; break; case "discs": echo "$Discs"; break; case "genre": echo "$Genre"; break; case "region": echo "$Region"; break; case "jahr": echo "$Jahr"; break; } echo "
\n"; $kesto_d=floor($totalruntime/(60*24)); $kesto_h=floor($totalruntime/60); $kesto_dh=$kesto_h-(24*$kesto_d); $kesto_m=$totalruntime-(60*$kesto_h); $kestoleffa = $totalruntime - $seriesruntime; echo "

$stis

"; echo "

features (discs) + series (discs) = discs

$feattotal ($featdiscs) + $seriestitles ($seriesdiscs) = $totaldiscs

\n"; echo "

total running time

$totalruntime mins
\n"; echo "or $kesto_h hours and $kesto_m mins
\n"; echo "or $kesto_d days, $kesto_dh hours and $kesto_m mins
\n"; $suhdesarja = round($seriesruntime / $totalruntime, 2); $suhdeleffa = round($kestoleffa / $totalruntime, 2); echo "(of which series takes $suhdesarja and movies $suhdeleffa.)

"; arsort($formats); ksort($regions); ksort($years); if(count($formats)>1) { echo "

titles / format

'; } echo "

regions

"; echo "

titles / year

\n"; if($static!="1") { echo "

$value) { echo "$key=$value&"; } echo "\">

\n"; echo '

The "How Much To Pay When Renting This Movie With A Group Of Friends" rating system

\n"; if($static!="1") { echo $navipalkki; } else { echo ''; } ?>