DVD Collection

connect(); $OddEven = 0; $Current = 0; ?> 0 ) { echo "DVD CollectionNo user selected. Please select one:
"; $r = mysql_query("SELECT ID, username FROM users"); while ($q = mysql_fetch_assoc($r)) { echo "".$q['username']."
"; } unset($q); unset($r); echo "

"; } else { $q = mysql_fetch_assoc(mysql_query("SELECT username FROM users WHERE ID=".$_REQUEST['user'])); $uname = $q['username']; ?> DVD Collection = 0) { $t = $t - 1.0; $l.= " $\"IMDB$ "; } elseif ($t - 0.5 >= 0) { $t = $t - 0.5; $l.= " $\"IMDB$ "; } else { $t = 0; $l.= " $\"IMDB$ "; } } } else { $l = "N/A"; } $Teller++; $IsNew = date_diff(date("Y-m-d", $rsDVD['DateAdded']), date("Y-m-d")); //Datediff("d", rsDVD("DateAdded"), Date()) switch ($IsNew) { case '0': $NewString = "Added Today"; break; case '1': $NewString = "Added 1 Day Ago"; break; default: $NewString = "Added ".$IsNew." Days Ago"; } if ($_REQUEST['Sortby'] == "New" && $IsNew < 10) { $Current++; ?> "> // // // // // // // // // ?>

DVD Collection
Choose other user

".$_SESSION['username']."
Add DVD - Logout"; } else { displayLogin(); } ?>

Sort List By:
Title
Date Added
IMDB Rating

Download / View this document as a PDF (NEW!)
New!

= Added Less Than 10 Days Ago
Show Only New Titles

Date Added

Title

IMDB Rating

<%=rsDVD("ID")%>

<%=rsDVD("DateAdded")%>

')">

" ALT=""> ')"><%=rsDVD("Title")%> <% If IsNew < 10 Then %> <%=NewString%>

<% End If %>

01-01-1970