[NCC1701]

Having trouble creating functions to display a list of values in a drop down menu, all i want to display is the menu option, this will evetually be coded so that when the user selects the menu name, the menu is displyed in a text box and will be able to edit it.

PHP Code:

<?php 
function get_menus()
{
  //query database
  $conn = db_connect();
  $query = "select menu_name
     from menu
   where menu_id = $menu_id";
  $result = @mysql_query($query);
  if (!$result)
   return false;
  $num_menus = @mysql_num_rows($result);
  if ($num_menus == 0)
    return false;
  $result = mysql_result($result, 0, 'menu_name');
  return $result;
}

 

function display_menu_form()
{
?>
  <form method="post" action="">
  <table align="center" border="0">
  <tr>
    <td><select name="menu_name">
 <?php 
   //selects menu list from menu database
   $menu_array=get_menus();
   foreach ($menu_array as $menu)
   {
     echo '<option value="';
  echo $menu['menu_name'];
  echo '"';
   }  
 ?>
 </select></td>
  </tr>
  </table>
  </form>
<?php 
}
?>

[NCC1701]

i think its to complecated above, can anyone provide a very simple script to list database items in a drop down menu?

[NeverMind]

it depends on what does the function get_menus() !
but generaly this is how you do drop downs from mysql:

PHP Code:

$fetch = mysql_query("SELECT value, item FROM table_1")or

die(mysql_error());



echo '<form method="POST" action="'.$_SERVER['PHP_SELF'].'">

<select name="menu_name">';



while($info = mysql_fetch_assoc($fetch)) {

  echo '<option value="'.$info['value'].'">'.$info['item'].'</option>';

}

echo'</select>

</form>'; 

[NCC1701]

thats really usefull thanks mate.

all i need to know now is when you select a option from the menu can you get it to display the corressponding data to do with the menu name?

[NeverMind]

altho I am not very sure about what you mean, but I think you will need to use OnChange so when you select an item it submits to the corressponding data ..
here, JavaScript is involved ..

[NCC1701]

what i mean is, say in my database i have two fields, menu_name and menu_text.


menu_name would be something such as Lunch, Starters, Mains etc

the menu_text would be the text in the database with all the menu items on.

what i want to be able to do is, when you click a menu option the menu text is displayed in a textarea below.

am i making sense?

[NeverMind]

oh, this also needs JavaScript with OnChange as I said

but I am not sure how it can be done since I am not expert in JavaScript..
but search the web for onchange uses and I am usre you will find good answers !

[NCC1701]

are you sure there is no way of doing without javascript, like a master detail form? if there isnt ill have a bash at the javascript

[NCC1701]

bump for replys

[blaw]

Hi there,

I would definitely use onChange event to refresh the page with the first combobox's selection as a GET var (and retrieve the corresponding data from the database with PHP upon refreshing the page).

With PHP, there is no way to listen to events once the page (i.e. HTML contents) is loaded. You have to use client-side scripting such JavaScript to handle these. I've heard ASP.NET is event-based and can do such, but I am not 100% sure how it does it.