Adding Values to dropdown Menu box from MySql_Fetch_Array

Question

Am attemtping to populate a dropdown menu with the results of my SQL query. The script functions, however I just am unsure of the syntax to add the results into the html dropdown menu. Currently it populates a table with the results. Here is my code:

<?php require_once('Connections/database.php'); ?>
<?php
$q=$_GET["q"];

mysql_select_db($database_db, $database);
$sql="SELECT cat_id, catname FROM categories WHERE cat_id = '".$q."'";

$result = mysql_query($sql);

echo "<table border='1'>
<tr>
<th>Category Name</th>
<th>Category ID</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['catname'] . "</td>";
  echo "<td>" . $row['cat_id'] . "</td>";

  echo "</tr>";
  }
echo "</table>";

mysql_close($database);
?>

Splashdust · Accepted Answer · 2010-10-13 00:56:54Z

2

This should do it:

<select name="input_name">
<?php
    while($row = mysql_fetch_array($result))
        echo "<option value='".$row['cat_id']."'>" . $row['catname'] . "</option>";
?>
</select>

answered Oct 13, 2010 at 0:56

Splashdust

7975 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zod · Accepted Answer · 2010-10-13 01:22:14Z

0

for menu , use

<ul>
<li><a href="#">Home</a></li>
<li><a href="#">Products</a></li>
<li><a href="#">Services</a></li>
<li><a href="#">About</a></li>
<li><a href="#">Contact</a></li>
</ul>



   <ul>
<?php
for(){
?>  
  <li><a href="#">$result[datafield]</a></li> 
}
?>
 </ul>

answered Oct 13, 2010 at 1:22

zod

12.5k25 gold badges74 silver badges107 bronze badges

1 Comment

Parker Over a year ago

Thank you!I can use this in my other page.

Collectives™ on Stack Overflow

Adding Values to dropdown Menu box from MySql_Fetch_Array

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related