so I am trying my hand at php again :)

[Techmonkey]

I have been working on a php/mysql page to display info about branches in a selected region for my work.

All is working, however I am trying to get it so the users can select a region from a combo box, click submit and then the page reloads with the correct region info.

Doesnt work though as the url it reloads is this: allregions.php?regionid='$rid' , '$rid' should be the actual value.

here is the code:

Code:

        <form action="allregions.php?regionid=$rid" $rid method="post">
    <select name="rid_combo" size="1" id="RID">  
<?php
    $query = "SELECT RID, region FROM tbl_regions";
    $result = mysql_query($query);

    while($row = mysql_fetch_assoc($result))
        {
            $RID = $row["RID"];
            $region = $row["region"];
            ?>
            
            <option value="<?php echo $RID; ?>"><?php echo htmlentities($region, ENT_QUOTES); ?></option>
            
            <?php
        } //End while
?>

    </select>

    <input type="submit" value="Update" />
    </form>

ok it may not be the prettiest code, but I dont care I just want this bit to work.

[Techmonkey]

w00t I R the win.

Damn post and gets grrr

[Neko]

Ah, looking on the query string rather than the form, were we?

[goll]

it's calling the var before it's declared. put the query before the form starts.