massive Posted February 28, 2006 Share Posted February 28, 2006 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 Quote Link to comment Share on other sites More sharing options...
soccer022483 Posted February 28, 2006 Share Posted February 28, 2006 Try changing your form to method = 'GET' and make sure your variables are in the address bar correctly. Quote Link to comment Share on other sites More sharing options...
XenoPhage Posted February 28, 2006 Share Posted February 28, 2006 Try printing the query to make sure it's what you're expecting. Quote Link to comment Share on other sites More sharing options...
massive Posted March 1, 2006 Author Share Posted March 1, 2006 [!--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 buttonit says:"Missing record ID"but my address bar where shown like this for example:(i know you got my point ^_^)somelink.php?id=chickenStep 11. source.php <-----where the variables came fromStep 22. 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 barim puzzled pls help tnx... Quote Link to comment Share on other sites More sharing options...
Snip Posted March 1, 2006 Share Posted March 1, 2006 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) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.