Code: Select all
<form name="jumper" action="template.php" method="get">
<select name="page" id="jumper">
<option selected><B>Select a Category</B></option>Code: Select all
<?php while ($row = mysql_fetch_assoc($result)) {
$page = $row["genre"];
$name = $row["genre"];
echo '<option value="' . $page . '">-' . $name . '</option>';
}
?>Code: Select all
</select>
<a href="javascript: submitform()"><img src="images/wrapper/jumper-go.gif" width="15" height="16" border="0" alt="Go" id="go"></a>
</form>-pet care
-automotive
-home
-pet care
-food
-automotive
Because I have 2 items with the genre 'pet care' and 2 items with 'automotive', i get this result. Whereas I only want each of those genres listed once.
Help!