Assuming, for the moment, that there's more code above that to actually support this...
You want to be quoting the keys in the array, and containing each array 'lookup' in
{}s:
print "$check[LNAME],$check[FNAME]($check[CID])";
Should be
print "{$check['LNAME']},{$check['FNAME']}({$check['CID']})";
However - in the future, try to include all relevant code. The surrounding table code
isn't important, but the code you're using for your query and to connect to the
database/etc. is.
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent those of St.
Jude Children's Research Hospital.
-----Original Message-----
From: Jason T. Davidson [mailto:[EMAIL PROTECTED]
Sent: Monday, November 01, 2004 3:11 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Forms list from database
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>
--
Jason Davidson
Juan Stiller wrote:
> It might be usefull to see the code you are using to
> show the query results.
>
> --- "Jason T. Davidson" <[EMAIL PROTECTED]>
> escribi�:
>
>>I am trying to take information from a database and
>>show that info in a
>>forms list. I have been trying this with while(),
>>but it never comes
>>out and displays correctly. Any help would be
>>appreciated.
>>
>>--
>>Jason Davidson
>>
>>--
>>PHP Database Mailing List (http://www.php.net/)
>>To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
>
>
>
>
>
>
> ___________________________________
> �Llevate a Yahoo! en tu Unif�n!
> Ahora pod�s usar Yahoo! Messenger en tu Unif�n, en cualquier momento y lugar.
> Encontr� m�s informaci�n en: http://ar.mobile.yahoo.com/sms.html
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
