Thanks. That sets the Select properly.
I'm still struggling with this though. No matter which product I pick I get first product (alphabetically) on my landing page.
I want to pick the product and then pass the ID# as a URL Parameter.
Here is my full form code:
<form id="form1" name="form1" method="post" action="product.php?ID=<?php echo $row_prods['ID']; ?>">
</p>
<select onchange="this.form.submit();" name="product" id="product" width="160" style="width: 160px">
<option value="" selected>Search by Product</option>
<?php
do {
?>
<option value="<?php echo $row_prods['ID']?>" ><?php echo $row_prods['Name']?></option>
<?php
} while ($row_prods = mysql_fetch_assoc($prods));
$rows = mysql_num_rows($prods);
if($rows > 0) {
mysql_data_seek($prods, 0);
$row_prods = mysql_fetch_assoc($prods);
}
?>
</select>
</form>