Default Menu/List Option

krotkruton

I'm trying to create a form with three menus, each with the same values, and I have no problems there. Each menu has it's initial value set at "None" and then the rest of the values are pulled from my MySQL db. Everything works great if the user selects three values that came from the database or selects something from the first menu but not the other two and then submits. The problem is when the user doesn't select anything from the first menu. The next page reads the form value as "" instead of "None" but only for the first menu. The other three menus work fine.

I know this isn't really php related, but this is usually such a helpful forum that I thought I'd post here before I start to search for some helpful html forum. Answers would be greatly appreciated, but so would corrections for my terminology (which I think I am confused about) or a good link to a place where I should be asking this question.

Thanks in advance,
Brendan

goldlikesnow

Can you post some code?

krotkruton

This should be all of the relevant code... with some extra stuff specific to my site, so just skip over that part...

$this_city = $_POST['cityName'];

mysql_select_db($database_connBarHopper, $connBarHopper);
$query_hometown_bars = "SELECT bar_name FROM barlist WHERE `city` = '$this_city'";
$hometown_bars = mysql_query($query_hometown_bars, $connBarHopper) or die(mysql_error());
//Left the next line out because it would require me to use a do-while loop below in the first menu
//$row_hometown_bars = mysql_fetch_assoc($hometown_bars);
$totalRows_hometown_bars = mysql_num_rows($hometown_bars);

.
.
.

<form action="user_bar_complete.php" method="post">
				<fieldset>
				<div align="center">
				  <p>
				    <legend><strong>Bar Destination Selection </strong></legend>
				  </p>
				  <p align="center">
				    <strong>Warning! </strong>Selecting a new bar from a menu will
				    replace the current bar you have set.
		          </p>
				  <label for="first">First Bar: <? echo $first_user_bar; ?></label><br/>
			              <select name="first">
						  		<option value="None">None</option>
            			    <?php 
								while ($row_hometown_bars = mysql_fetch_assoc($hometown_bars)) {  

							?>
 				               <option value="<?php echo $row_hometown_bars['bar_name']?>" ><?php echo $row_hometown_bars['bar_name']?></option>
			                <?php
								} 
							?>
    			          </select><br/>
						  <? mysql_data_seek($hometown_bars, 0); ?>
					  <label for="second">Second Bar: <? echo $second_user_bar; ?></label><br/>
			              <select name="second">
						  		<option value="None">None</option>
            			    <?php 
							while ($row_hometown_bars = mysql_fetch_assoc($hometown_bars)) {  

							?>
 				               <option value="<?php echo $row_hometown_bars['bar_name']?>" ><?php echo $row_hometown_bars['bar_name']?></option>
			                <?php } ?>
    			          </select><br/>
						  <? mysql_data_seek($hometown_bars, 0); ?>
					  <label for="third">Third Bar: <? echo $third_user_bar; ?></label><br/>
			              <select name="third">
						  		<option value="None">None</option>
            			    <?php 
								while ($row_hometown_bars = mysql_fetch_assoc($hometown_bars)) {
							?>
 				               <option value="<?php echo $row_hometown_bars['bar_name']?>" ><?php echo $row_hometown_bars['bar_name']?></option>
			                <?php } ?>
    			          </select><br/>
					  <label for="submit">&nbsp;</label>
					  <p>
						    <input id="submit" name="submit" type="submit" value="Submit">
</p>
					  <p>Bars listed above the menus are the bars you currently have set as
					    your destination</p>
					  <p>Note: You do not need to select 3 bars at this time, or ever, but you
					    have the option of doing so if you choose. There is also
					    no difference between the bars you select, so &quot;First
					    Bar&quot; is not the bar you like more than &quot;Second Bar,&quot;
					    it's just the first bar on the list.</p>
				</div>
				</fieldset>
			</form>