[SOLVED] drop down list from database

[new_php85]

iii how to get value from database for dropdown list

 

<select class="special" name="year">
<option value="" selected>Staff Name
<option value="<?php echo $row['staff_name']?>" ><?PHP while($row = mysql_fetch_assoc($result))
			                  {
						echo $row['staff_name'];
                                                                      }?> 
</select>

this is code that i have done. it appear but the name not go down like JosephJoLinaAlex

suppose like this

 

Joseph

Jo

Lina

Alex

[The Little Guy]

take a look at this, maybe it will help out some: http://phpsnips.com/snippet.php?id=10

 

You also need a closing option tag:

 

<option value="something">Some Text</option>
<option value="something">Some More Text</option>
<option value="something">Etc...</option>

[dropfaith]

i use this and seems to be exactly what your looking for

<select name="Cat">
<?php
// includes
include("../template/conf.php");
// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");
// generate and execute query				
$query = "SELECT * FROM galleryname";				
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// if records present
if (mysql_num_rows($result) > 0)
{
// iterate through resultset
// print article titles
while($row = mysql_fetch_object($result))
{
?>
<option value="<? echo $row->Gallery; ?>"><? echo $row->Gallery; ?></option>
<?php
}
}
// if no records present
// display message
else
{
?>
<option>No option</option>
			<?php
			}
			// close database connection
			mysql_close($connection);
			?>

[new_php85]

i use this and seems to be exactly what your looking for

<select name="Cat">
<?php
// includes
include("../template/conf.php");
// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");
// generate and execute query				
$query = "SELECT * FROM galleryname";				
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// if records present
if (mysql_num_rows($result) > 0)
{
// iterate through resultset
// print article titles
while($row = mysql_fetch_object($result))
{
?>
<option value="<? echo $row->Gallery; ?>"><? echo $row->Gallery; ?></option>
<?php
}
}
// if no records present
// display message
else
{
?>
<option>No option</option>
			<?php
			}
			// close database connection
			mysql_close($connection);
			?>

 

i... thank you for your info. i got it..........