$timestamp = mysql_result($proQuery, 0, "timestamp");
        $bc = "shoe";
        //default container is a shoe
        //retrieves container id from products
        $container = mysql_result($proNameQuery, 0, "containerID");
        //queries the container name from the container table
        $query = "SELECT Name FROM containers WHERE ID = {$container} ";
        $contNames = !is_null($query) ? mysql_query($query) : null;
        $containerName = mysql_result($contNames, 0, "Name");
        if (!($quantity == 1)) {
            $bc = $containerName . "s";
        } else {
            $bc = $containerName;
        }
        $dateOfInsertion = new dateTime();
        $dateOfInsertion->setTimestamp(strtotime($timestamp));
        echo "<tr style='vertical-align:top;text-align:center;height:1em;margin-right:auto;margin-left:auto;background-color:";
        if ($productCounter % 2) {
            echo "#b3d9ff";
        } else {
            echo "white";
        }
        //every even row is this color
        echo "'>\r\n\t\t\t\t\t<td>" . $dateOfInsertion->format('d M Y') . "</td>\r\n\t\t\t\t\t<td>" . $productName . "</td>\r\n\t\t\t\t\t<td>" . $quantity . " " . $bc . "(" . $volume . "oz)</td>\r\n\t\t\t\t\t<td>" . $quantity * $volume . " oz</td>\r\n\t\t\t\t\t<td>" . $abv . "%</td>\r\n\t\t\t\t\t<td>\$" . $price . "</td>\r\n\t\t\t\t\t<td>\$" . number_format($price / ($quantity * $volume), 3) . "</td>\r\n\t\t\t\t\t<td>\$" . number_format($price / ($abv / 100 * ($quantity * $volume)), 3) . "</td>\r\n\t\t\t\t\t</tr>";
    } elseif (mysql_num_rows($proNameQuery) == 0) {
    }
    //a price in this town belongs to a product that does not match the search results. no big deal.
}
echo "</tbody></table>";
//insert the failed search result method after the price table
if (isset($_GET['search']) && $productCounter == 0) {