7) $stknum = decode($code,23); logs($stknum); $result = mysql_query("SELECT * FROM dvds WHERE stknum='$stknum'",$db); $number = mysql_numrows($result); if ($number < 1) { $stknum = rand(1004000,1006000); $result = mysql_query("SELECT * FROM dvds WHERE stknum='$stknum'",$db); } $title = mysql_result($result,0,"title"); $subtitle = mysql_result($result,0,"subtitle"); $howsold = mysql_result($result,0,"howsold"); //$rentprice = mysql_result($result,0,"rentprice"); if ($number < 1) { $totalnumtorent =-1; $numtorent =0; } else { $totalnumtorent = mysql_result($result,0,"totalnumtorent"); $numtorent = mysql_result($result,0,"numtorent"); } $sellprice_new = mysql_result($result,0,"sellprice_new"); $sellprice_used = mysql_result($result,0,"sellprice_used"); $discount_new = mysql_result($result,0,"discount_new"); $discount_used = mysql_result($result,0,"discount_used"); $totalnumtobuy = mysql_result($result,0,"totalnumtobuy"); $numtobuy = mysql_result($result,0,"numtobuy"); $totalnumtosell_used = mysql_result($result,0,"totalnumtosell_used"); $genre = mysql_result($result,0,"genre"); $director = mysql_result($result,0,"director"); $actors = mysql_result($result,0,"actors"); $rating = mysql_result($result,0,"rating"); // Movie database Version 4.0 implenentation $description = mysql_result($result,0,"description"); $description = str_replace("<","<",$description); $copyright = mysql_result($result,0,"copyright"); $features = mysql_result($result,0,"features"); $features = str_replace("<","<",$features); $features = ""; // end of Implementation $additionalfeatures = mysql_result($result,0,"additionalfeatures"); $videoformat = mysql_result($result,0,"videoformat"); $audiotracks = mysql_result($result,0,"audiotracks"); $numofdiscs = mysql_result($result,0,"numofdiscs"); $layers = mysql_result($result,0,"layers"); $sides = mysql_result($result,0,"sides"); $otherinfo = mysql_result($result,0,"otherinfo"); $date = mysql_result($result,0,"releasedate"); //$imageinfo = mysql_result($result,0,"imageinfo"); //$imagefront = mysql_result($result,0,"imagefront"); //$imageback = mysql_result($result,0,"imageback"); $imageinfo = "/covers/".$stknum."fi.jpg"; $imagefront = "/covers/".$stknum."fl.jpg"; $imageback = "/covers/".$stknum."bl.jpg"; $yy = substr($date,0,4); $mm = substr($date,5,2); $dd = substr($date,8,2); $directory="/covers/"; if ($totalnumtorent != -100) { $showrent = "Q Members:
Add This To Your Q Cart!"; $addtoq = encode($stknum,23); //$addtoq=$stknum; $showimagerent = "

"; } else { $showrent = ""; $showimagerent = ""; } //if (($totalnumtobuy - $numtobuy) >= 0) { //$showbuy = " Add This To Your ShoppingCart!"; //$showimagebuy = "

"; //} else { //$showrent = ""; //$showimagerent = ""; //} if ($totalnumtobuy != -1) { $saleprice_new = $sellprice_new - $discount_new; $showbuy = "Price \$"."$sellprice_new"; if ($discount_new > 0){ $showbuy2 = "SALE \$"."$saleprice_new"; } else { $showbuy2 = ""; } $showimagebuy = "

"; } else { $showbuy = ""; $showbuy2 = ""; $showimagebuy = ""; } if ($totalnumtosell_used >0) { $saleprice_used = $sellprice_used - $discount_used; $showbuyused = "Price \$"."$sellprice_used"; if ($discount_used > 0){ $showbuyused2 = "SALE \$"."$saleprice_used"; // $showbuyused2 = " SALE \$"."10.95"; } else { $showbuyused2 = ""; } $showimagebuyused = "

"; } else { $showbuyused = ""; $showbuyused2 = ""; $showimagebuyused = ""; } $result = mysql_query("SELECT * FROM variables WHERE varname='buyoption'",$db); $buyoption = mysql_result($result,0,"varvalue"); //***********test************* //$buyoption=1; //***********test************* ?>

$genre2[$n]"; // echo ("genre2[".$n."] = ".$genre2[$n]."
"); } $newgenre=implode(", ",$genre2); ?> $directorcast[$n]"; // echo ("directorcast [".$n."] = ".$directorcast[$n]."
"); } $newdirector=implode(", ",$directorcast); ?> $cast[$n]"; // echo ("cast [".$n."] = ".$cast[$n]."
"); } $newcast=implode(", ",$cast); ?>

",$newvideo); $newvideo = str_replace(";","
",$newvideo); $newvideo = str_replace("
W","W",$newvideo); ?> ",$newaudio); $newaudio = str_replace(";","
",$newaudio); ?>

Video:

Audio:

Description:



Date Released: //			Sides\|Layers:
Copyright:			Other Info: