Populating Dropdown menus

[Ammar]

Hi, I've been trying to populate a drop down menu with dates from a database, and then filter a list by the chosen date. The problem is that only one date appears. The list can be filtered by that one date, so thats not an issue

$qry = mysql_query("
SELECT		 posted
FROM		  $table_name
WHERE		 trash = 'n'
ORDER BY	posted DESC
");
	while ($row = mysql_fetch_array($qry)) {
	$id			= $row['id'];
	$posted		= $row['posted'];
	}
	?> 

//form (fpo is a variable I use for filtering the list)
<select name="fpo" value="<? echo $fpo; ?>" style="width:100%; font-family:Arial, Helvetica, sans-serif">
<option value="">All Dates</option>
<option value="<? echo $posted; ?>"><? echo $posted; ?></option></select>

So again, the problem is, is that only one date appears in the list. Any input is appreciated, Thanks in advance
-Ammar

[tomhath]

You need to print the options inside the while loop:

//form (fpo is a variable I use for filtering the list)
<select name="fpo" value="<? echo $fpo; ?>" style="width:100%; font-family:Arial, Helvetica, sans-serif">
<option value="">All Dates</option>
<?
$qry = mysql_query("
SELECT	posted
FROM		$table_name
WHERE	 trash = 'n'
ORDER BY	posted DESC
");
while ($row = mysql_fetch_array($qry)) {
	$id			= $row['id'];
	$posted		= $row['posted'];
	?> 

<option value="<? echo $posted; ?>"><? echo $posted; ?></option>

<?
}
?> 
</select>

[Ammar]

That did it, thanks for the help😃