DaniWeb Forum Index > Web Development > PHP

Displaying Data in Drop down menu

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2008

Posts: 217

Reputation: mrcniceguy is an unknown quantity at this point

Solved Threads: 4

mrcniceguy mrcniceguy is offline

Offline

Posting Whiz in Training

Displaying Data in Drop down menu

Aug 9th, 2008

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))))

•

Join Date: Jul 2008

Posts: 1,076

Reputation: Shanti Chepuru is on a distinguished road

Solved Threads: 98

Shanti Chepuru Shanti Chepuru is offline

Offline

Veteran Poster

Re: Displaying Data in Drop down menu

Aug 9th, 2008

hello check this code:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$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";
$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";