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:davidson@xxxxxxxxxxxx]
Sent: Monday, November 01, 2004 3:11 PM
To: php-db@xxxxxxxxxxxxx
Subject: Re: 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" <davidson@xxxxxxxxxxxx>
> 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
