[RESOLVED] Dynamic Pull Down

[dtwconsulting]

Trying to get the following code to work. Fairly simple, or should be 🙂 Just trying to populate a pulldown with values from a MySQL database table.

I have checked the SQL and that is working fine...not that difficult.

So, why is it when I run this the pull down just contains the word --Select-- and then a bunch of blanks?

$sqlOptions = "SELECT MEDIA_NAME, MEDIA_ID from MEDIA_TYPES";
$result = mysql_query($sqlOptions);
if (!$result) {
echo ("<P>Error performing query: " . mysql_error() . "</P>");
exit();
}

echo '<select name="Test">';
echo '<option value="">--Select--</option>';
while($opt = mysql_fetch_array($result))
{
echo '<option value="'.$opt['MEDIA_ID'].'">'.$opt['MEDIA_TYPE'].'</option>';
}
echo '</select>';

[devinemke]

<?php
$result = mysql_query('SELECT MEDIA_NAME, MEDIA_ID from MEDIA_TYPES') or exit(mysql_error());
if (!mysql_rum_rows($result)) {exit('no records found');}

echo '
<select name="Test">
<option value="">--Select--</option>
'; 

while ($row = mysql_fetch_assoc($result))
{
	echo '<option value="' . $row['MEDIA_ID'] . '">' . $row['MEDIA_TYPE'] . '</option>';
}

echo '</select>';
?>

[dtwconsulting]

Devinemke,

Thanks for the feedback. I tried this and still blanks 🙁

Here is the code as it currently stands:

$result = mysql_query('SELECT MEDIA_NAME, MEDIA_ID from MEDIA_TYPES');
if (!mysql_num_rows($result)) {exit('no records found');}

echo '<select name="Test">';
echo '<option value="">--Select--</option>';
while ($row = mysql_fetch_assoc($result))
{
echo '<option value="' . $row['MEDIA_ID'] . '">' . $row['MEDIA_TYPE'] . '</option>';
}
echo '</select>';

[dtwconsulting]

Sorry all, this was one of those stupid things 🙁

I was selecting MEDIA_NAME but trying to populate the select with MEDIA_TYPE. No wonder it was coming out with blanks.

Sorry to have wasted peoples time on something so silly.

[jara06]

no problem. We've all been there 😉

Just remember to resolve your threads when they are 🙂