Skip to main content
wefollow
wefollow
Inspiring
July 30, 2009
Answered

dropdown menu

  • July 30, 2009
  • 2 replies
  • 963 views

It is very easy to make the Dropdown menu form Ms Access.

But how can i make the Dropdown menu from Phpmyadmin........

Advice or article....

Thank you for reading..

This topic has been closed for replies.
Correct answer

First of all, you must create recordset for the drop down menu (Server Behaviour > Recordset). Then, insert the drop down menu on page (Insert > Form > List/Menu) and insert the appropriate id for it. Click it and look at the properties panel below. You can see "Dynamic" button, click it and you will get popup window as below.

You can see "Options from recordset" field. Choose the recordset that u have made before. Values field is for attribute that you want to store in database and Labels field to show the list to users when they choose.

2 replies

A
Anonymous
August 2, 2009

1. <select name="my_drop_down" id="drop_down_id">
2. <?php
3. do {  ?>
4. <option value="<?php echo $row_recordset['row_containing_value']?>">
5. <?php echo $row_recordset['row_containing_display']?></option>
6. <?php
7. } while ($row_recordset = mysql_fetch_assoc($recordset));
8. $rows = mysql_num_rows($recordset);
9.  if($rows > 0) {
10. mysql_data_seek($recordset, 0);
11. $row_recordset = mysql_fetch_assoc($recordset);
12.  } ?>
13. </select>

In line 4 we are setting the value from the table that will act as the value for the menu.  Whereas in line 5 we are setting the value from the table that will be displayed in the menu... in many cases this is the same (but also in many cases it won't be)... most notably if you want to, for example, display someone's name in the menu, but set the value as the id number of that person's record.

A
Anonymous
August 2, 2009

Oh, also in DW you can just make the menu and then click "Dynamic..." in the properties panel and follow the steps.

A
Anonymous
July 31, 2009

Do u mean that u want to make dynamic drop down that will list some values from table in databse?

wefollow
wefollowAuthor
Inspiring
July 31, 2009

thank you very much for read my mind...

The answer is Yes.

A
Anonymous
Correct answer
August 3, 2009

First of all, you must create recordset for the drop down menu (Server Behaviour > Recordset). Then, insert the drop down menu on page (Insert > Form > List/Menu) and insert the appropriate id for it. Click it and look at the properties panel below. You can see "Dynamic" button, click it and you will get popup window as below.

You can see "Options from recordset" field. Choose the recordset that u have made before. Values field is for attribute that you want to store in database and Labels field to show the list to users when they choose.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices