[RESOLVED] Problem population select FORM

fearfx

I have to select forms, one for states and countries, my countries form works but my states one does not. I am kinda confused why the states select FORM will not populate from MySql.

<tr>
			  <td class="label">State:</td>
			  <td class="field">
				<select name="state">
				<?php if (isset($_POST['state'])) { ?>
				  <option selected value="<?php echo $_POST['state'] ?>"><?php echo $_POST['state'] ?>
				<?php } ?>
				<option value="">
				<?php 
				  $result = mysql_query("SELECT abbrv, states FROM wsd_states ORDER BY states");
				  if ($result) {
					if ($frow = mysql_fetch_row($result)) {
					  do {
					    echo '<option value="' . $frow[0] . '">' . $frow[1];
					  } while ($frow = mysql_fetch_row($result));
					}
				  }

			  ?>
			</select></td>
	    </tr>
		<tr>
		  <td class="label">Country:</td>
		  <td class="field">
			<select name="country">
			<?php if (isset($_POST['country'])) { ?>
			  <option selected value="<?php echo $_POST['country'] ?>"><?php echo $_POST['country'] ?>
			<?php } ?>
			<option value="">
			<?php 
			  $result = mysql_query("SELECT country, country_name FROM wsd_countries ORDER BY country_name");
			  if ($result) {
				if ($frow = mysql_fetch_row($result)) {
				  do {
				    echo '<option value="' . $frow[0] . '">' . $frow[1];
				  } while ($frow = mysql_fetch_row($result));
				}
			  }

			  ?>
			</select>			  </td>
		</tr>

This page is a part of my current project, if you need you can go to okauchee.fearfx.com/login.php - login using user: tester | pass: test

then click profile on the top navigation.

Thats the page where I display the to select forms.

roscor

Try altering your Query to see the result

$result = mysql_query("SELECT * FROM wsd_states WHERE states = $_POST['state'] ORDER BY states");

Then try changing to

<?php
                  $result1 = mysql_query("SELECT * FROM wsd_states WHERE states = $_POST['state'] ORDER BY states");
                  if ($result1) {
                    if ($frow1 = mysql_fetch_row($result1)) {
                      do {
                        echo '<option value="' . $frow1[0] . '">' . $frow1[1];
                      } while ($frow1 = mysql_fetch_row($result1));
                    }
                  }

              ?>

It may be causing parse problems with having similar queries?

fearfx

why was this added to the query?

WHERE states = $_POST['state']

fearfx

still messing around, but still isn't working...

roscor

The Value from your Select (if populated from your database or array needs echoing into the select) needs sending as a value to Your database within the query.

fearfx

roscor wrote:
The Value from your Select (if populated from your database or array needs echoing into the select) needs sending as a value to Your database within the query.

Sending the selected state to be inserted into the database is done elsewhere, and either way, when I entered your version I get errors T_Encasped

roscor

<?php

         $states = $_POST['state'] ;
              $result1 = mysql_query("SELECT * FROM wsd_states WHERE states = `$states` ORDER BY states");
              if ($result1) {
                if ($frow1 = mysql_fetch_row($result1)) {
                  do {
                    echo '<option value="' . $frow1[0] . '">' . $frow1[1];
                  } while ($frow1 = mysql_fetch_row($result1));
                }
              }

              ?>

roscor

Try a print_r($_POST) to see what values are held in the variable?