Jump to content

Having problems updating using drop-down menu


massive

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
Link to comment
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...
Link to comment
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)
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.