// GET OTHER CARD VERSIONS
   $getversionsSQL = "SELECT * FROM cardDB WHERE cardname = '".mysqli_real_escape_string($conn, $getcardinfo['cardname'])."' ORDER BY released_at ASC";
   $getversionsQUERY = mysqli_query($conn, $getversionsSQL);
 
    ?></h3>
 
<table id="cardinformation" style="width:100% !important;">
<tr><td style="width:400px; vertical-align:top;">
       <?php if($getcardinfo["format"] != "sealed") { ?>
        <div class="tilt__item">
          <img class="tilt__item-inner" src="https://api.scryfall.com/cards/<?php echo $getcardinfo["scryfallid"];?>?format=image&version=large" alt="<?php echo $getcardinfo["cardname"]." - ".$getcardinfo["edition"];?>" />
          <div class="tilt__overlay"></div>
        </div>
        <?php } else {?>
         <img src="images/sealedproducts/<?php echo $getcardinfo["scryfallid"];?>.png" alt="<?php echo $getcardinfo["cardname"]." - ".$getcardinfo["edition"]." - ".$getcardinfo["mana_cost"];?>" style="max-height:350px; max-width: 420px; padding-right:30px;" />
        <?php }?>
<?php
  $getvaluesSQL = "SELECT recorded, value, valueFoil FROM cardvalueDB WHERE scryfallid = '".$sid."'";
  $getvaluesQUERY = mysqli_query($conn, $getvaluesSQL);
  $checkvaluesDB = mysqli_num_rows($getvaluesQUERY);
  if ($checkvaluesDB > 0) {
  ?>
  <br>
  <div style="margin-top:20px;">
  <h4>Average Values</h4>
  <table class="statisticblock">
  <tr><td>
  Week:</td>
  <?php
  $getvaluesSQL = "SELECT recorded, value, valueFoil FROM cardvalueDB WHERE scryfallid = '".$sid."' AND (recorded >= DATE(NOW()) - INTERVAL 7 DAY)";
  $getvaluesQUERY = mysqli_query($conn, $getvaluesSQL);
  $counts = 0; $sum = 0;
  $countsFoil = 0;  $sumFoil = 0;
 
  while( $getvaluesWeek = mysqli_fetch_array($getvaluesQUERY)) {
    $sum = $sum + $getvaluesWeek["value"];
    $sumFoil = $sumFoil + $getvaluesWeek["valueFoil"];
    if($getvaluesWeek["value"] !== "0.00" ) {$counts++;}
    if($getvaluesWeek["valueFoil"] !== "0.00" ) {$countsFoil++;}