Anonymous

<?php
require_once ("common.php");

if (!isset($_GET['page']))
{
    $page = 1;
}
else
{
    $page = $_GET['page'];
}

$max_results = 10;
$from = (($page * $max_results) - $max_results);

$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM champagnes"),
    0);
$total_pages = ceil($total_results / $max_results);

if ((!isset($_POST['type'])) || ($_POST['type'] == "%"))
{
    $type = "%";
}
else
{
    $type = $_POST['type'];
}
$query = mysql_query("SELECT type_id, type FROM champagne_type ORDER by type");

?>
<link href="admin.css" rel="stylesheet" type="text/css" />

<table width=100%>
<tr>
<td>
<div align="right">
<form action="main.php?action=show_champagnes" method="post" name="show_champagnes" id="show_champagnes">
  <select name="type" class="dropdowns" id="type">
    <option value="%">-- Select Type --</option>
    <?php
while ($row = mysql_fetch_array($query))
{
    {
	$linkname = urlencode($row['type']);
	echo "<option value=".$linkname.">".$row['type']."</option>";
    }
}
?>
    <option value="%">--------------------------</option>
    <option value="%">View All</option>
  </select>
  <input name="Submit" type="submit" class="fields" value="Show" />
</form>
</div></td>
</tr>
</table>

<?
$query = mysql_query("SELECT champagne_id, type, name, price, notes, size, alcohol, offer, justarrived, thumb, image, status FROM champagnes WHERE type like '" .
    $type . "' ORDER BY price ASC LIMIT $from, $max_results");

if (!$query)
{
    echo mysql_error();
}
echo "<font size='1' face='Verdana, Arial, Helvetica, sans-serif'>";
echo "<table width='100%' style='font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px'>";
echo "<tr bgcolor=#7F92A4 style='color:#ffffff;'><td width=40%>Name</td><td width=5%><center>Price</center></td><td width=40%>Tasting Notes</td><td width=5%><center>Size (ml)</center></td><td width=6%><center>Alcohol %</center></td><td width=29px>Image</td><td width=10%>Edit</td><td width=10%>Delete</td><td>Status</td></tr>";
$colcount = 1;
while ($row = mysql_fetch_array($query))
{
    $name = $row['name'];
    if ($colcount == "1")
    {
        $bgcol = "#DEDEDE";
        $colcount = "2";
    }
    else
    {
        $bgcol = "#EFEFEF";
        $colcount = "1";
    }
    echo "<tr bgcolor=" . $bgcol . "><td>" . $row['name'] . "</td><td><center>" . $row['price'] .
        "</center></td><td>" . $row['notes'] . "</td><td><center>" . $row['size'] .
        "</center></td><td><center>" . $row['alcohol'] .
        "</center></td><td><center><a href=../prod_images/" . $row['thumb'] .
        " target=_blank><img src=../prod_images/" . $row['thumb'] .
        " width=29 height=100 border=0></a></center></td><td><a href=main.php?action=edit_c_frm&champagne_id=" .
        $row['champagne_id'] .
        "><center><img src=edit.png border=0></center></a></td><td><a href=main.php?action=delete_champagne&champagne_id=" .
        $row['champagne_id'] . " onClick=\"return confirm('Are you SURE you want to delete this? The process can not be reversed!')\"><center><img src=delete.png border=0></center></a></td>";

    if ($row['status'] == "0")
    {
        $status = "disabled";
    }
    else
    {
        $status = "enabled";
    }

    echo "<td><center>" . $status . "</center></td></tr>";
}
echo "</table></font><br>";
if ($prevnext == "yes")
{
    echo "<center>";
    if ($page > 1)
    {
        $prev = ($page - 1);
        echo "<font size='1' face='Verdana, Arial, Helvetica, sans-serif'><a href=main.php?action=show_champagnes&page=$prev class=PageLink> << prev</a>&nbsp; |&nbsp; ";
    }
    for ($i = 1; $i <= $total_pages; $i++)
    {
        if (($page) == $i)
        {
            $posts .= "$i ";
        }
        else
        {
            echo "<font size='1' face='Verdana, Arial, Helvetica, sans-serif'><a href=main.php?action=show_champagnes&page=$i class=PageLink>$i</a>&nbsp; |&nbsp; ";
        }
    }
    // Build Next Link
    if ($page < $total_pages)
    {
        $next = ($page + 1);
        echo "<font size='1' face='Verdana, Arial, Helvetica, sans-serif'><a href=main.php?action=show_champagnes&page=$next class=PageLink>next >></a>";
    }
    echo "</center>";
    echo "</br>";

}
?>