To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 01 November 2004 21:11, Jason T. Davidson wrote: > Here is the code: > > <form name="form1" method="post" action="staff_code/add_code.php"> > <table width="600" border="0" align="center" cellpadding="0" > cellspacing="0"> <tr bgcolor="#CCCCCC"> > <td colspan="3" bgcolor="#FFFFFF"><div align="center"> > <select name="controller" id="controller"> > <option> </option> > <option> > <? > while ($check=mysql_fetch_array($result)){ > print "$check[LNAME],$check[FNAME]($check[CID])"; > } > > > </option> > </select> > </div></td> > </tr> I think you're missing some <option></option> tags -- these should be present around each value extracted from the database, so: while ($check=mysql_fetch_array($result)){ print "<option>{$check['LNAME']},{$check['FNAME']}({$check['CID']})</option>\n"; } Cheers! Mike --------------------------------------------------------------------- Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning & Information Services, JG125, James Graham Building, Leeds Metropolitan University, Headingley Campus, LEEDS, LS6 3QS, United Kingdom Email: m.ford@xxxxxxxxxxxxxx Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php