Form Select Value

[neverforget98]

Hey everyone,

I am coding a script for a nonprofit I work for. I have done this before but it was many many moons ago. Basically, I have a portion of the site called "InfoMaster" which tracks, enrolls and unenrolls our volunteers. This piece of the system has the landing page which lists all active volunteers, and has a hyperlink for the name so you can go to the InfoMaster Overview Page, which shows an individual volunteer. From there, you can edit the Info by clicking the "Edit Info" link. This page is sys_volup.php. It pulls the information and two of the fields are dropdowns. One for Grade and one for Free Block. The values for this will be coded into the script and not kept in the database as there is only up to 5 values for each. What I need to happen though, is when the edit page populates, it selects the current value (from the database - e.g. Grade is 12), and use this on the dropdown as the select value, so that way if you do not edit that field, it doesn't change to the default value of "10" when you submit the form.

The code isn't written yet for this small piece, I just need to know what I need to put in. If you need any information from me let me know. Values are pulled using:

.$infomaster['grade'].

Grades are Ten, Eleven and Twelve.

Thanks!

[NogDog]

You many want to store the last-selected grade in a session variable (if I'm correctly understanding the issue). Then your select element might look something like...

<?php
session_start();
?>
<!-- a bunch of beautiful HTML, including the start of your form -->
<select name="grade">
<?php
foreach(array(10 => 'Ten', 'Eleven', 'Twelve') as $gradeNbr => $gradeName)
{
    printf(
        "<option value='%d'%s>%s</option>\n",
        $gradeNbr,
        (isset($_SESSION['grade']) and $_SESSION['grade'] == $gradeNbr) ? " selected='selected'" : '',
        $gradeName
    );
}
?>
</select>
<!-- the rest of your form and amazing HTML -->

[dalecosp]

What I need to happen though, is when the edit page populates, it selects the current value (from the database - e.g. Grade is 12), and use this on the dropdown as the select value, so that way if you do not edit that field, it doesn't change to the default value of "10" when you submit the form.

So, what exactly are you needing help with? You've stated your plan of action; it seems sound.

//userid
$user     = $some_variable_that_you_must_already_have_to_show_the_correct_page; // an integer?  probably should be...

$db        = my_db_connect_function(); // if you need this ask.  I guess I'm assuming Mysql(I).

$sql       = "select grade from myTable where id = $user;";

$result   = $db->query( $sql );

if ($result) {
   $row = $result->fetch_assoc();
   $grade = $row['grade'];
}

// Now put NogDog's foreach() here for output, substituting $grade for the $_SESSION['grade'] variable....