getting data from table to display in dropdown

gilmourt

Hi,

I've got some code which saves the business division into the main table. It does this fine, but when I want to review what has been entered into the table it will not display properly... not really explaining this well. Basically when the user hits edit, previous entery they should see all the data they previously entered and it allows them to ammend it. But the values that they previously chose should be visable, but they are not. Heres some snipits of code which should do it, or so I thought.

$sql_business_division_query=mysql_query("SELECT * FROM business_division ORDER BY division ASC"); //gets the business divisions

$sql_item_query=mysql_query("SELECT items.* ..... , business_division.division AS business_division ....
LEFT JOIN business_division ON items.division_ID=business_division.ID

<td class="field_display_text">
<select class='normal_form_field' name='division'>
<option value="">Select a division.....</option>
<option value=""></option>
<?php

                                                                                                                                    while ($sql_business_division_row=mysql_fetch_array($sql_business_division_query))
                                                                                                                                    {

                                                                                                                                            if ($sql_business_division_row["ID"] == $sql_item_row["business_division_ID"])
                                                                                                                                            {
                                                                                                                                                    print "<option value=\"".$sql_business_division_row["ID"]."\">".$sql_business_division_row["division"]."</option>";
                                                                                                                                            } elseif($sql_business_division_row["active"]=="yes") {
                                                                                                                                                    print "<option value=\"".$sql_business_division_row["ID"]."\">".$sql_business_division_row["division"]."</option>";
                                                                                                                                            }
                                                                                                                                    }
                                                                                                                            ?>
                                                                                                                      </select>
                                                                                                                    </td>

steadyguy

Not sure I entirely understand your problem, but on first glance ... you don't have any <form> tags - the form won't submit without them (and a submit button) - or a JavaScript function that submits for you.

gilmourt

sorry, ive not really explained it well above.. Ive already had all the data submitted from another apge and its been input into my table with no problems. Now I'm trying to call all the data back again so that the user can alter it if they have made a mistake.

What I gave above was just a few bits of the code which I thought might have contained an error.

I've attached the php code for the whole page if that helps. But the part i'm having the problem with is getting the value that the user previously entered in business division to appear as the selected option in the drop down menu 😕

steadyguy

Ahh ... I see. You can do that by adding the attibute selected="selected" to the appropriate option:

elseif($sql_business_division_row["active"]=="yes") {
print "<option value=\"".$sql_business_division_row["ID"]."\" selected=\"selected\">".$sql_business_division_row["division"]."</option>";
}

By the way ... if you use extract() on your result array in the loop, you can just use the column names instead of indexed array variables. (ie., $ID instead of $sql_business_division_row["ID"]