$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) {
