Edit data based on select

[jgurgen]

What i am trying to do is based on the selected item gather data from the database and edit it. I have the drop list populated but i dont know how to get it so that when a user selects an item to generate the page with the data.

here is my php code so far.

                                        Edit District Contact: <?php
                                          // establish constants
										  $host="xxxxxx";
                                          $user="xxxxxx";
                                          $password="xxxxxx";
							              $database="xxxxxx";

                                      // connect to database
                                      mysql_connect($host, $user, $password);
				  @mysql_select_db($database) or die( "Error:ES-1001 N/A please contact webmaster @ [e-mail]");

                                      // Variable Declaration
                                      $sql="select District_Name from District";
                                      $result=mysql_query($sql);
                                      $numitems = mysql_query("select count(*) from district");

                                      // Create select options from result
                                      echo($numitems."<br>");
                                      Print "<form><select><option>Select School...</option>";
                                      while($row = mysql_fetch_array($result))
                                      {
                                        Print "<option value='".$row['District_Name']."'>".$row['District_Name']."</option>";
                                      }
                                      Print "</select></form>";

                                      // Close Connection
                                      mysql_close();
									 ?>

[zingbats]

Could you explain in more detail what you're hoping to achieve?

[jgurgen]

im trying to allow someone to select a school from a drop down list. After they select the school reload the page with data from that school into textboxes so they can make changes and save it back to the database.

[zingbats]

Well there are two ways to do this.

One is to use Javascript and XMLHttpObject (commonly refered to as ajax)
The other way is to post the form to itself / another page and do a DB query based on the postdata from the initial form 🙂

[jgurgen]

im going to post the form to itself but i cant find any tutorials online on it.
below i included the form i want to post the data in, but i have no idea how to do this.

<form id="districts">
<p>Edit District Contact: </p>
<?php

                    Print "<script language='JavaScript'>";
                    Print "funtion teamdata(){";
                    Print "window.location.href='http://www.WEBSITE.com/phpTest.php?="+document.districts.SelectSchool.value+"'";
                    Print "}";
                    Print "</script>";?>

                    <?php
                                      // establish constants
									  $host="xxxxx";
                                      $user="xxxxx";
                                      $password="xxxxx";
						              $database="xxxxx";

                                      // connect to database
                                      mysql_connect($host, $user, $password);
				  @mysql_select_db($database) or die( "Error:ES-1001 N/A please contact webmaster @ ");

                                      // Variable Declaration
                                      $sql="select District_Name from District";
                                      $result=mysql_query($sql);
                                      $numitems = mysql_query("select count(*) from district");

                                      // Create select options from result
                                      echo($numitems."<br>");
                                      Print "<select id='SelectSchool' name='SelectSchool' onchange='javascript:teamdata(this.value)'><option>Select School...</option>";
                                      while($row = mysql_fetch_array($result))
                                      {
                                        Print "<option value='".$row['District_Name']."'>".$row['District_Name']."</option>";
                                      }

                                      Print "</select>";


                                      // Close Connection
                                      mysql_close();
									 ?>
                  </form>
                  <p></p>
                  <div align="left">
                    <form id="DistrictInfo">
                      <table>
                        <tr>
                          <td>District Name: </td>
                          <td>
                            <input id="District"/>
                          </td>
                        </tr>
                        <tr>
                          <td>Contact First: </td>
                          <td>
                            <input id="ConFirst"/>
                          </td>
                        </tr>
                        <tr>
                          <td>Contact Last: </td>
                          <td>
                            <input id="ConLast"/>
                          </td>
                        </tr>
                        <tr>
                          <td>Contact Phone: </td>
                          <td>
                            <input id="ConPhone"/>
                          </td>
                        </tr>
                        <tr>
                          <td>Contact Email: </td>
                          <td>
                            <input id="ConEmail"/>
                          </td>
                        </tr>
                        <tr>
                          <td>Secondary Contact First: </td>
                          <td>
                            <input id="SecConFirst"/>
                          </td>
                        </tr>
                        <tr>
                          <td>Secondary Contact Last: </td>
                          <td>
                            <input id="SecConLast"/>
                          </td>
                        </tr>
                        <tr>
                          <td>Secondary Contact Phone: </td>
                          <td>
                            <input id="SecConPhone"/>
                          </td>
                        </tr>
                        <tr>
                          <td>Secondary Contact Email: </td>
                          <td>
                            <input id="SecConEmail"/>
                          </td>
                        </tr>
                        <tr>
                          <td>District Website: </td>
                          <td>
                            <input id="Website"/>
                          </td>
                        </tr>
                        <tr>
                          <td>
                            <button id="submit" value="Submit" type="submit" style="width:75px">Submit</button>
                          </td>
                        </tr>
                      </table>
                    </div>
                  </form>[/QUOTE]

[zingbats]

http://www.x-code.com/vdaemon/samples/selfsubmit.php

Take a read of this, it might help you understand the concept of a self posting form.

[jgurgen]

thanks but that wasn't really what i was looking for at all