php/mysql drop down menu

[truck7758]

Hi,

 

Im having a bit of trouble getting a drop down menu to populate with data from my sql database

I have this code which makes a drop down menu:

<?

$category = array(

 

);

$category = str_replace(" ", " ", $category);

 

echo '<SELECT name=category>';

foreach ($category as $key => $value)

{

echo '<OPTION value='.$value.'> '.$value.'';

}

echo '</select>';

 

?>

 

and this creates the list of the data i want in the drop down menu:

<?

 

$mysqli = new mysqli('localhost','username','password');

$mysqli->select_db('orders');

 

$result = $mysqli->query("SELECT * FROM user");

 

while($row = $result->fetch_assoc()) {

print $row['name'] . '<br/>';

}

 

$result->close();

 

?>

 

Was just looking for some help on how to merge the two, if possible

 

Thanks,

Mike

[truck7758]

have sorted it now using the following:

 

$mysqli = new mysqli('localhost','username','password');

$mysqli->select_db('orders');

 

$result = $mysqli->query("SELECT * FROM user");

 

echo '<SELECT name=category>';

while($row = $result->fetch_assoc()) {

echo '<OPTION>'.$row['name'].'</option>';

}

echo '</select>';

 

$result->close();