Deleting an ID from a drop down

[Strikerz]

Okay, so I have a drop down menu that gives names from a database. How would I make it so when I click the delete button, it deletes the entire id for the selected user in the drop down . The database name is something and the names from the drop down are in a table called users.

<select name="user">
		<?php
			mysql_connect(localhost, "root", "xxxx");
			@mysql_select_db(something) or die ("Unable to connect to database.");

		$query= "SELECT name FROM users";
		$result = mysql_query($query);
		if(mysql_num_rows($result))
			{
			      while($row = mysql_fetch_row($result))
			{
				print("<option value=\"$row[0]\">$row[0]</option>");
			}
			}
	   ?>
</select>
</td>
<td>
<input type="submit" name="delete" value="Delete">
</tr>

[jkurrle]

when you submit the value to the processing script, you would need to use GET or POST to get the value, then insert it into a delete statement. Here's an example:

echo "<form method=\"post\" action=\"somescript.php\">
  <select name=\"deadguy\">";

$query="select `id_num`, `name` from `user_table` order by `name`";
$connection=mysql_connect($server,$login_id,$password)
  or die("Error connecting to server - ".mysql_error());
$db=mysql_select_db("dbname",$connection)
  or die("Error selecting database - ".mysql_error());
$result=mysql_query($query)
  or die("Error running SELECT statement - ".mysql_error());
mysql_close($connection);

while($row=mysql_fetch_array($result,MYSQL_ASSOC))
  {
  extract($row);
  echo "<option value=\"$id_num\">$name</option>\r\n";
  }

echo "</select>
  <input type=\"submit\" value=\"Delete\" />
  </form>";

This sends a variable called "deadguy" and sets the value to $id_num. The processing script would do something like this:

$deadguy=$_POST['deadguy']; // Get the POST'ed data...

$delete="delete from `user_table` where `id_num`=\"$deadguy\"";
$connection=mysql_connect($server,$login_id,$password)
  or die("Error connecting to server - ".mysql_error());
$db=mysql_select_db("dbname",$connection)
  or die("Error selecting database - ".mysql_error());
$result=mysql_query($delete)
  or die("Delete from usertable had errors - ".mysql_error());
mysql_close($connection);