dynamic drop down

[chill84]

i don’t know if this is possible but i want to create a drop down menu with options based on what is in a database. could someone help me with the code.

[Weedpacket]

Yes, it is possible. What work have you done so far?

[chill84]

ok i got it to work but now it will not display the text from the datbase. heres the code or the webpage is http://216.145.16.34/db/summary.php

code:

<?php
// Request the text of all the brothers
$result = @("SELECT * FROM alumni_meeting");

if (!$result) {
exit('<p>Error performing query: ' . mysql_error() . '</p>');
}

while ($row = mysql_fetch_array($result)) {
echo '
<option value="' . $row['Date'] . '">' . $row['Date'] . '</option>
';
}
?>
</select>
<input type="submit" value="Submit" name="B2"><input type="reset" value="Reset" name="B3"></p>
</form>
</td>
</tr>
<?php
// Request the text of all the brothers
$result = @("SELECT * FROM alumni_meeting WHERE Date = '" . $_POST['D1'] . "'");

if (!$result) {
exit('<p>Error performing query: ' . mysql_error() . '</p>');
}

while ($row = mysql_fetch_array($result)) {
echo '

					</td>
				</tr>

				<tr>
					<td align="left" valign="top" colspan="2">
					<p align="center"><img src="' . $row['extra'] . '"></td>
					<td>&nbsp;</td>
				</tr>

				<tr>
					<td align="left" valign="top" colspan="2">
					<p align="justify"><font size="2" face="Verdana" color="#000000">' . $row['Summary'] . '</font></td>
				</tr>

			';

}
?>

[chill84]

the last part is the part that no longer works when you select the date it is to display the text for that selection but nothing is happening. whats wrong?

[chill84]

nm got it to work
thanks