RE: Forms list from database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux