Re: populate pulldownbox from query [message #174073 is a reply to message #174072] |
Sat, 21 May 2011 02:29 |
Chuck Anderson
Messages: 63 Registered: September 2010
Karma:
|
Member |
|
|
Jeff North wrote:
> On Fri, 20 May 2011 11:30:02 -0700 (PDT), in comp.lang.php Co
> <vonclausowitz(at)gmail(dot)com>
> <7e34dca3-a1f3-4bdf-acbd-8288e6a30581(at)gu8g2000vbb(dot)googlegroups(dot)com>
> wrote:
>
>
>> | Hi All,
>> |
>> | I am having trouble populating a pulldownbox with records from a table
>> | in mySQL database.
>> |
>> | I have a table with personnel records.
>> | One of the fields is partner which holds a numeric value pointing to
>> | the id of another record.
>> | I am trying to get the value of the currently selected person's
>> | partner.
>> |
>> | for example:
>> | id=1 name=John partner=2
>> | id=2 name=Jane partner=1
>> |
>> | With the code I use I do get the pulldownbox filled but it doesn't
>> | display the name right partner info in the box.
>> |
>> | $query="SELECT id, firstname, lastname, rank FROM myMembers WHERE id
>> | <> $id ORDER BY lastname";
>> | $result = mysql_query ($query);
>> | echo "<select name=partner class=formFields id=partner
>> | value=''>Partner</option>";
>> | while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
>> | echo "<option value=$nt[id]>$nt[rank] $nt[firstname] $nt[lastname]</
>> | option>";
>> | /* Option values are added by looping through the array */
>> | }
>> | echo "<option value=$partner>$nt[rank] $nt[firstname] $nt[lastname]</
>> | option>";
>> | echo "</select>";// Closing of list box
>> | ?>
>> |
>> | Can anyone help me here?
>> |
>> | Regards
>> | Marco
>>
>
> When you View Source of the page what do you see where the lists are
> supposed to be (there could be php error messages hiding there).
>
I always get tripped up by that one as it's common (for me) to output
the select tag followed by a php loop to create options. This puts the
error message within the select block and the browser does not display it.
--
*****************************
Chuck Anderson • Boulder, CO
http://cycletourist.com
Turn Off, Tune Out, Drop In
*****************************
|
|
|