Displaying Data in Drop down menu

[mrcniceguy]

CAn any one show me code or explain how i can display data from mysql database in drop down menu.
I will appreciate your Help))))

[Shanti C]

hello check this code:

$strQuery = "select $intID, $strName from $tableName order by $strOrderField $strMethod";
  $rsrcResult = mysql_query($strQuery);

  while($arrayRow = mysql_fetch_assoc($rsrcResult)) {
   $intIdField = $arrayRow["$intID"];
   $strNameField = $arrayRow["$strName"];
   echo "<option value=\"$intIdField\">$strNameField</option>\n";
  }

  echo "</select>\n\n";

[Shanti C]

For more dynamic dropdown with changing second dropdown....
Refer this url:
http://www.plus2net.com/php_tutorial/php_drop_down_list.php

[mrcniceguy]

thank you))it works.