Need help adding Delete option on a php form

[NCC1701]

This function populates a drop down menu with database field, when a choice from the menu is made and the Edit Menu button is pressed, another function is called elsewhere to dispaly the full results.

Now i have added a delete button but i cant for the life of me figure out how to delete the chosen menu, ive tried using if(isset($_POST['delete']) and then performing the delete but i just cant get it to work, can anyone help me. Also im trying to figure out a way of separating most of the php code into a different function but with no success.

This funtion is called from a file named menu_selection.php

<?php
display_menu_selection_form()
{
  // create connection
      $conn = db_connect();
      if (!$conn)
      return false;

  // create SQL statement
  $query = "SELECT *
            FROM menu";
  // execute SQL query and get result
  $sql_result = mysql_query($query,$conn);
  //check to see if there are results from the query
  if (!$sql_result) 
  { 
    echo("<p>Error performing query: " . mysql_error() . "</p>"); 
  } 
  $num=mysql_num_rows($sql_result);
  if($num>0)
  {
    // format results by row into option list
    while ($row = mysql_fetch_array($sql_result))
    {
      $menu  = $row["menu_name"];
      $option_block .= "<option value=\"$menu\">$menu</option>";
    }
  }
?>
  <form method="post" action="menu_edit.php">
  <table align="center" border="0">
  <tr>
    <td>
	<select name="menu_name">
	<?php echo "$option_block"; ?>
	</select> 
	</td>
  </tr>
  <tr>
    <td>
	<input type="submit" value="Edit Menu" name="submit">
	<input type="submit" value="Delete Menu" name="delete">
	</td>
  </tr>
  </table>
  </form>
<?php
};
?>

thanks
NCC1701

[travelbuff]

I think there are a couple of things you should look at...

First, I would suggest reading these threads: http://www.phpbuilder.com/board/showthread.php?threadid=10248489 and http://www.phpbuilder.com/lists/php-general/2000122/0637.php . Since you didn't post the content of the html form, not sure where your problem is.....

Second, consider using a checkbox and one submit button, then check the value of the box and delete or not based on that.

[NCC1701]

i had a look at those threads mate and ive tried the different submit options and it didnt work, i tried adding:

if (isset($_POST['delete'])){

$query = "DELETE FROM menu
                 WHERE menu_name = $menu_name";

}

but it didnt work it jsut kept going to the menu_edit screen, i just want the record to be deleted from the menu_selection screen, i dont need it to go anywhere else.

[VirtualOdin]

I am not sure if this is a good answer, but I would make the delete button something like:

<input type='button' value='Delete' onClick=\"window.open('yourpage.php?action=delete&menu_name=whateveritis', '_self');\">";

You need to put the menu item value in 'whateveritis' or put it somewhere the page can get at it again

Then add a routine high up your page like this
<?php
if ($action == "delete")
{
$query = "DELETE FROM menu
WHERE menu_name = $menu_name";
$sql_result = mysql_query($query,$conn);
}
?>

Then you can either allow the page to continnue to load as before or 'exit;' as you wish.

Tim