how do I display records from MySQL DB using the select code

[webguync]

Hi I have a form with JS that autopopulates a subform when a user selects a state. The subform is then populated with cities from that state eg Texas with Dallas, Houston, Austin etc,

I then need to insert php code which will interact with a MySQL DB table to select a field ID to display records for a unique city. I am not exactly how to do that. I know how to connect to a DB and table to the part I need assistance with is the interaction with the form code which is this:

<table>
<tr>
<form name="classic">
  <select name="countries" size="4" onChange="updatecities(this.selectedIndex)" style="width: 150px">
  <option selected>Select A State and City</option>
  <option value="AL">AL</option>
ption>

  </select>

</td>
<td>
  <select name="cities" size="4" style="width: 150px" onClick="alert(this.options[this.options.selectedIndex].value)">
  </select>
  </form>

<script type="text/javascript">

  var countrieslist=document.classic.countries
  var citieslist=document.classic.cities

  var cities=new Array()
  cities[0]=[""]
  cities[1]=["Auburn|auburnvalue", 
  function updatecities(selectedcitygroup){
  citieslist.options.length=0
  if (selectedcitygroup>0){
  for (i=0; i<cities[selectedcitygroup].length; i++)
  citieslist.options[citieslist.options.length]=new Option(cities[selectedcitygroup][i].split("|")[0], cities[selectedcitygroup][i].split("|")[1])
  }
  }

</script>
</td>
</tr>
</table>

[painfull]

G'day Webguy,

I recently built a page to 'edit' members of my DB. My code queries my DB and inserts the results into a form for editing - then re-inserting into (updating) my DB.

I'm having trouble with the updating the DB part, but for now my 'query and display' code works. Perhaps this will help you.

$check = mysql_query("SELECT * FROM users")
or die(mysql_error());

echo "<p align='center'>&nbsp;</p>";
echo "<p align='center'>&nbsp;</p>";
echo "<table border='1' align='center'>";
echo "<tr><th width='90' align='center'>Username</th>";
echo "<th width='120' align='center'>Name</th>";
echo "<th width='70' align='center'>Status</th></tr>";
while($users = mysql_fetch_array( $check )){
$username = $users['username'];

echo "<tr><td align='center'>";
echo "<a href='$username'>$username</a>";
echo "</td><td>";
echo $users['name_f'] . " " . $users['name_l'];
echo "</td><td>";
echo $users['status'];
echo "</td><td width='50' align='center'>";
echo "<a href='/edit_users.php?name=$username';>Edit</a>";
echo "</td></tr>";
}
echo "</table>";

You'll notice I have seperated the username from the results and given that a variable of it's own. This is something I found I had to do to be able to use a variable in a href link. This helps me use that name in a $_GET address line query. When I click on a user in the list some more code injects the record for that user into a form for editing.

That bit works also, so far. Just need to put it back in my DB now :p I'm working on that :s
Hope this helps.

Cheers mate.

P.