Beers On Tap
Other Beer
Red Wine
White Wine

Beers On Tap
[insert_php] $conn=mysqli_connect(“localhost”,”flat3558812913″,”n*#p.ER+GY-C”,”flat3558812913″);

$x = 1;
$sql = “SELECT beverages.ID, “;
$sql = $sql . “beverages.name, “;
$sql = $sql . “beverages.desc, “;
$sql = $sql . “beverages.price, ” ;
$sql = $sql . “beverages.active, “;
$sql = $sql . “beverages_catagory.ID, “;
$sql = $sql . “beverages_catagory.catagory “;
$sql = $sql . “FROM “;
$sql = $sql . “beverages “;
$sql = $sql . “INNER JOIN “;
$sql = $sql . “beverages_catagory ON beverages.catagory = beverages_catagory.ID “;
$sql = $sql . “where “;
$sql = $sql . “beverages_catagory.ID = ” . $x . ” ” . ” AND beverages.active = 1 “;
$sql = $sql . “ORDER BY name”;

//echo $sql . “

“;

$result = $conn->query($sql);

if ($result->num_rows >= 1)
{
$i = 0;

while($row = $result->fetch_assoc())
{
if($i == 0)
{

// $html = “beer-of-the-month-2 “;

$html = “

” . $row[“catagory”] . “

“;
$html .= “

“;
$html .= “
“;
}
if($i >= 1 && $i <= 4) { //$html = "< style='padding-top: 2em; padding-bottom: 2em;' img src='https://flatrockwoodroom.com/images/bar/" . $i . ".png' alt='beer-of-the-month-2' class='alignright size-full' /> “;

}
$html .= “

“;

if ($i % 2 == 0 )
{
$strClass = “odd”;
}
else
{
$strClass = “even”;
}

$html .= “

” . $row[“name”] . “

“;
$html .= “

” . $row[“desc”] . “

“;
$html .= “

$” . $row[“price”] . “

“;
$i = $i + 1;
//$html =. “

” . . ” ” . $row[“desc”] . ” ” . “” . $row[“price”] . “

“;
$html .= “

“;

}

$html .= “

“;
$html .= “

“;

echo $html;
}

[/insert_php]

Beer On Tap

Other Beer

[insert_php] $conn=mysqli_connect(“localhost”,”flat3558812913″,”n*#p.ER+GY-C”,”flat3558812913″);

$x = 2;
$sql = “SELECT beverages.ID, “;
$sql = $sql . “beverages.name, “;
$sql = $sql . “beverages.desc, “;
$sql = $sql . “beverages.price, ” ;
$sql = $sql . “beverages.active, “;
$sql = $sql . “beverages_catagory.ID, “;
$sql = $sql . “beverages_catagory.catagory “;
$sql = $sql . “FROM “;
$sql = $sql . “beverages “;
$sql = $sql . “INNER JOIN “;
$sql = $sql . “beverages_catagory ON beverages.catagory = beverages_catagory.ID “;
$sql = $sql . “where “;
$sql = $sql . “beverages_catagory.ID = ” . $x . ” ” . ” AND beverages.active = 1 “;
$sql = $sql . “ORDER BY name”;

//echo $sql . “

“;

$result = $conn->query($sql);

if ($result->num_rows >= 1)
{
$i = 0;

while($row = $result->fetch_assoc())
{
if($i == 0)
{

// $html = “beer-of-the-month-2 “;

$html = “

” . $row[“catagory”] . “

“;
$html .= “

“;
$html .= “
“;
}
if($i >= 1 && $i <= 4) { //$html = "< style='padding-top: 2em; padding-bottom: 2em;' img src='https://flatrockwoodroom.com/images/bar/" . $i . ".png' alt='beer-of-the-month-2' class='alignright size-full' /> “;

}
$html .= “

“;

if ($i % 2 == 0 )
{
$strClass = “odd”;
}
else
{
$strClass = “even”;
}

$html .= “

” . $row[“name”] . “

“;
$html .= “

” . $row[“desc”] . “

“;
$html .= “

$” . $row[“price”] . “

“;
$i = $i + 1;
//$html =. “

” . . ” ” . $row[“desc”] . ” ” . “” . $row[“price”] . “

“;
$html .= “

“;

}

$html .= “

“;
$html .= “

“;

echo $html;
}

[/insert_php]

Other Beer

Red Wine

[insert_php] $conn=mysqli_connect(“localhost”,”flat3558812913″,”n*#p.ER+GY-C”,”flat3558812913″);

$x = 3;
$sql = “SELECT beverages.ID, “;
$sql = $sql . “beverages.name, “;
$sql = $sql . “beverages.desc, “;
$sql = $sql . “beverages.price, ” ;
$sql = $sql . “beverages.active, “;
$sql = $sql . “beverages_catagory.ID, “;
$sql = $sql . “beverages_catagory.catagory “;
$sql = $sql . “FROM “;
$sql = $sql . “beverages “;
$sql = $sql . “INNER JOIN “;
$sql = $sql . “beverages_catagory ON beverages.catagory = beverages_catagory.ID “;
$sql = $sql . “where “;
$sql = $sql . “beverages_catagory.ID = ” . $x . ” ” . ” AND beverages.active = 1 “;
$sql = $sql . “ORDER BY name”;

//echo $sql . “

“;

$result = $conn->query($sql);

if ($result->num_rows >= 1)
{
$i = 0;

while($row = $result->fetch_assoc())
{
if($i == 0)
{

// $html = “beer-of-the-month-2 “;

$html = “

” . $row[“catagory”] . “

“;
$html .= “

“;
$html .= “
“;
}
if($i >= 1 && $i <= 4) { //$html = "< style='padding-top: 2em; padding-bottom: 2em;' img src='https://flatrockwoodroom.com/images/bar/" . $i . ".png' alt='beer-of-the-month-2' class='alignright size-full' /> “;

}
$html .= “

“;

if ($i % 2 == 0 )
{
$strClass = “odd”;
}
else
{
$strClass = “even”;
}

$html .= “

” . $row[“name”] . “

“;
$html .= “

” . $row[“desc”] . “

“;
$html .= “

$” . $row[“price”] . “

“;
$i = $i + 1;
//$html =. “

” . . ” ” . $row[“desc”] . ” ” . “” . $row[“price”] . “

“;
$html .= “

“;

}

$html .= “

“;
$html .= “

“;

echo $html;
}

[/insert_php]

Red Wine

White Wine

[insert_php] $conn=mysqli_connect(“localhost”,”flat3558812913″,”n*#p.ER+GY-C”,”flat3558812913″);

$x = 4;
$sql = “SELECT beverages.ID, “;
$sql = $sql . “beverages.name, “;
$sql = $sql . “beverages.desc, “;
$sql = $sql . “beverages.price, ” ;
$sql = $sql . “beverages.active, “;
$sql = $sql . “beverages_catagory.ID, “;
$sql = $sql . “beverages_catagory.catagory “;
$sql = $sql . “FROM “;
$sql = $sql . “beverages “;
$sql = $sql . “INNER JOIN “;
$sql = $sql . “beverages_catagory ON beverages.catagory = beverages_catagory.ID “;
$sql = $sql . “where “;
$sql = $sql . “beverages_catagory.ID = ” . $x . ” ” . ” AND beverages.active = 1 “;
$sql = $sql . “ORDER BY name”;

//echo $sql . “

“;

$result = $conn->query($sql);

if ($result->num_rows >= 1)
{
$i = 0;

while($row = $result->fetch_assoc())
{
if($i == 0)
{

// $html = “beer-of-the-month-2 “;

$html = “

” . $row[“catagory”] . “

“;
$html .= “

“;
$html .= “
“;
}
if($i >= 1 && $i <= 4) { //$html = "< style='padding-top: 2em; padding-bottom: 2em;' img src='https://flatrockwoodroom.com/images/bar/" . $i . ".png' alt='beer-of-the-month-2' class='alignright size-full' /> “;

}
$html .= “

“;

if ($i % 2 == 0 )
{
$strClass = “odd”;
}
else
{
$strClass = “even”;
}

$html .= “

” . $row[“name”] . “

“;
$html .= “

” . $row[“desc”] . “

“;
$html .= “

$” . $row[“price”] . “

“;
$i = $i + 1;
//$html =. “

” . . ” ” . $row[“desc”] . ” ” . “” . $row[“price”] . “

“;
$html .= “

“;

}

$html .= “

“;
$html .= “

“;

echo $html;
}

[/insert_php]

White Wine