RE: [PHP-DB] Forms list from database
| From: | Norland, Martin | Date: | Mon, 01 Nov 2004 21:21:56 +0000 |
| Subject: | RE: [PHP-DB] Forms list from database | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37108@lists.php.net to get a copy of this message | ||
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@aero.und.edu]
Sent: Monday, November 01, 2004 3:11 PM
To: php-db@lists.php.net
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" <davidson@aero.und.edu>
> 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