Jump to content

Archived

This topic is now archived and is closed to further replies.

massive

Having problems updating using drop-down menu

Recommended Posts

Hi guyz, i have trouble in updating my data using drop-down menus...im trying to upgrade a subscribers ServiceType....but its seems i have so problems... i don't know whats wrong with it here is a part of my script:

-------script for querying---------

[code]
<?  

    if((!isset($_GET['id']) || trim($_GET['id']) == ''))
        {
            die('Missing record ID!');
        }

    $connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS) or die('Unable to connect!');
    mysql_select_db(DB_NAME) or die('Unable to select database');
    $id = $_GET['id'];
    $q = "SELECT username, ServiceType FROM subscription WHERE username = '$id'";
    $w = mysql_query($q) or die("Error in query: $q. " . mysql_error());
  
    if(isset($_POST['change']))
    {
    
        $query  = "UPDATE subscription SET ServiceType = '" . $_POST['service'] . "' WHERE username = '$id'";
    $result = mysql_query($query) or die("Error in query: $query. " . mysql_error());
  
  }
  if($result)
  {
      header("Location: updatesuccess.php");
  }
?>    [/code]

-----html drop down menu declaration----------
[code]
<select name="service">
          <option>-----------</option>
          <option value="NR5">NR5</option>
          <option value="NR10">NR10</option>
          <option value="NR15">NR15</option>
          <option value="NR20">NR20</option>
          <option value="NR25">NR25</option>
          <option value="NR30">NR30</option>
          <option value="NR40">NR40</option>
          <option value="NR50">NR50</option>
          <option value="NR60">NR60</option>
          <option value="NR80">NR80</option>
          <option value="NR100">NR100</option>
          <option value="NR120">NR120</option>
          <option value="R10">R10</option>
          <option value="R20">R20</option>
          <option value="R30">R30</option>
          <option value="R40">R40</option>
          <option value="R50">R50</option>
          <option value="R60">R60</option>
          <option value="R80">R80</option>
          <option value="R100">R100</option>
          <option value="R120">R120</option>
        </select>

[/code]

------here is the submit button declaration--------
[code]
<input type="submit" name="change"  value="Upgrade">
[/code]

hmmm i'm quite puzzled...wondering where did i go wrong pls help...thank you

Share this post


Link to post
Share on other sites
[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]

Try changing your form to [b]method = 'GET' [/b]and make sure your variables are in the address bar correctly.

[/quote]

oh yeah i have'nt tried that ^_^ and about the address bar the variables are shown fine ^^...but the thing is everytime i press the button


it says:



"Missing record ID"

but my address bar where shown like this for example:(i know you got my point ^_^)

somelink.php?id=chicken



Step 1

1. source.php <-----where the variables came from

Step 2
2. geting.php?id=chicken <------where the variables were transfered and data chickens information was displayed here...yet when i press the button in the geting.php page....click....then "Missing record ID" (T_T)
come to think of it the variables where shown in both the address bar and at the status bar

im puzzled pls help tnx...

Share this post


Link to post
Share on other sites
Here is what I've come up with.
[code] //$user = $_POST['user']
             $url = $_SERVER["PHP_SELF"];
                
                echo "<form method=\"get\" name=\"userselection\" action=\"$url\">";
                echo '<select size="1" name="user" onchange="forms[\'userselection\'].submit()"> ';
                while($i<$num){
                      /* Output combo box */
                      $value=mysql_result($result,$i);
                    echo("<option value=");
                    echo( $value );
                         if(strtolower($user)==strtolower($value)){
                           echo " selected=true";
                    }
                    echo(">");
                    echo( $value );
                    echo("</option>");
                    $i++;
                }
                echo("</select>");
                echo '</form>';[/code]

When you select a different item in the combobox, the page gets reloaded and you get the new value from the $_POST on witch you can readjust the data on your page (and reput the combobox on the selected item)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.