Allowing update of record

[NCC1701]

Im trying to make this funciton display_edit_menu() update the record but i dont know how to go about doing it, would anyone be able to assist me, thanks
NCC1701

<?php

function 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
  $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="Sumbit" name="Submit"></td>
  </tr>
  </table>
  </form>
<?php
};

function display_menu_edit_form()
{
// create connection 
      $conn = db_connect();
      if (!$conn)
      return false;

  // create SQL statement 
  $query = "SELECT menu_id, menu_name, menu_text 
            FROM menu 
			WHERE menu_name = '$_POST[menu_name]' ";
  // execute SQL query and get result 
  $sql_result = mysql_query($query,$conn);

  //check to see if there are results from the query
  $num=mysql_num_rows($sql_result);
  if($num>0)
  {	   
    // format results by row
    while ($row = mysql_fetch_array($sql_result)) 
    {
	  $menu_id = $row["menu_id"];
      $menu_name = $row["menu_name"];
      $menu_text = $row["menu_text"];
    }
  } 
?>
  <form method="post" action="menu_edit.php">
  <table align="center">
   <tr>
     <td colspan=2>Edit Menu Contents</td>
   </tr>
   <tr>
     <td><input type="hidden" name="menu_name" value="<? echo $menu_id ?>"></td>
   </tr>
   <tr>
     <td>Menu Name</td>
     <td><input type="text" name="menu_name" value="<? echo $menu_name ?>"></td></tr>
   <tr>
     <td>Menu Content</td>
     <td>
	 <textarea><? echo $menu_text ?></textarea>
	 </td>
   </tr>
   <tr>
     <td colspan=2 align=center>
     <input type="submit" value="Update"></td>
   </tr>   

 </table></form>
<?php
};
?>

[tude-marie]

Think you need to explain what you want from this?

The code you have right now will display the last row that the query returns in a form. Except you need to run

mysql_select_db("db_name", $conn);

If you want the information the form submits to be updatet into a row, do something like this:

First of all change the name of your hidden input to something else than menu_name, pref. menu_id.

Next you need to give the textarea a name for later reference, something like name="menu_text" comes to mind.

When you have done that, you will need to add the following php code at the top of your function:

if(!empty($_POST['menu_name']) && !empty($_POST['menu_text'])) // check if the input fields contain any info
{
   $update_was_a_success = mysql_query("UPDATE menu SET menu_name = '".$_POST['menu_name']."', menu_text = '".$_POST['menu_text']."' WHERE menu_id = '".$_POST['menu_id']."'") or die("AARRRGH something fucked up !".mysql_error());
   if($update_was_a_success)
   {
      echo "Query updated";
   }
}

[NCC1701]

Sorry i should have explained more, the first funciton is used to display a list of menus that is populated by a database. Once a selection is made the submit button is pressed which displays the menu name and the menu text in another form which can then be edited, once edited the new information needs to update the database.

ill give what you suggested a go, thanks for your help

[NCC1701]

ok, ive got this far, i dont get any errors but when you change the menu text in the text area and click update, it just displays the previous text and does not update. I dont understand what im doing wrong

if (isset($_POST['submit']) && ($_POST['submit']=='Update') ) 
     {
       $menu_id= $_POST['menu_id'];
       $menu_name = $_POST['menu_name'];
       $menu_text = $_POST['menu_text'];
       $query = "UPDATE menu SET menu_text = '$menu_text', menu_name = '$menu_name'
                 WHERE menu_id = '$menu_id'";
       $sql_result = mysql_query($query);
       echo "Thank you! Information updated.\n";
      }
      // create SQL statement 
      $query = "SELECT menu_id, menu_name, menu_text 
                FROM menu 
				WHERE menu_id = " . $_POST['menu_id'];
      // execute SQL query and get result 
      $sql_result = mysql_query($query,$conn);

  //check to see if there are results from the query
  $num=mysql_num_rows($sql_result);
  if($num>0)
  {	   
    // format results by row
    while ($row = mysql_fetch_array($sql_result)) 
    {
	  $menu_id = $row["menu_id"];
      $menu_name = $row["menu_name"];
      $menu_text = $row["menu_text"];
    }