combobox

[Boris77]

I want to make a combobox within it names of people... which i got from a mysql database... but it width this code it won't work... can anyone say what the problem is?

<form action="classer.php" method="post">

<?php

mysql_connect('localhost','*****','****');
mysql_select_db('db*****');

$gift="SELECT * from docenten order by abbrname";
$result=mysql_query($gift);

?>
<p>
<select name="teachername">
<OPTION>
<?php
while($name=mysql_fetch_array($result))
{
$name= $name[1]." ".$name[2];
}
?>
</OPTION>
</select>

<input type="submit" name="send" value="classlist" />
</p>
</form>

thanx

[stolzyboy]

try this, it is assuming that your database field name is name

if not

change $name['name']

to

$name['fieldname']

<form action="classer.php" method="post"> 

<?php 

mysql_connect('localhost','********','**********')
; 
mysql_select_db('db********'); 

$gift = "SELECT * from docenten order by abbrname"; 
$result = mysql_query($gift); 

?> 
<p> 
<select name="teachername"> 

<?php 
while($name = mysql_fetch_array($result)) 
{
?>
<OPTION><? echo $name['name']; ?></OPTION>  

<?
} 
?> 

</select> 

<input type="submit" name="send" value="classlist" /> 
</p> 
</form>

[Boris77]

Thanx stolzyboy...

it worked.

Superb!!!