Populating a drop down box with a query

[joesaddigh]

I am having trouble populating a dropdown box from a query. It seems to work fine in the sense that there is the correct amount of values however you cannot see them.

 

<?php
//A dropdown box populated from the language table to display all of the languages
require "connectstudent.php";
$querylang="SELECT language FROM language";
   
$resultlang = mysql_query($querylang);
echo "<select name=category value=''></option>";

while($lang= mysql_fetch_array($resultlang))
{
	echo "<option value=$lang[language]</option>";
}
echo "</select>";// Closing of list box
?>

Thanks

[kickstart]

Hi

 

Try taking the </option> off the line that puts out the select.

 

All the best

 

Keith

[joesaddigh]

Thanks Keith

[jcombs_31]

You still need </option>, but you are missing a closing brace > and aren't displaying the value inside the option tag.

 

<option value='something> Put IT Here too </option>

[kickstart]

You still need </option>, but you are missing a closing brace > and aren't displaying the value inside the option tag.

 

Doh, should have spotted that. However he has an extra </option> without an opening option.

 

All the best

 

Keith