elis Posted January 31, 2007 Share Posted January 31, 2007 Here's a snippet of my coding:[code]$position= $_POST['position'];$appc="SELECT * FROM tssettings";$query=mysql_query($appc);$res=mysql_fetch_array($query);<select name=\"position\"><OPTION SELECTED name=\"position\" VALUE=\"Positions Available\">Positions Available</option>";if(!$res[position_1_t]==""){$command.="<option name=\"position\" value=\"$res[position_2_t]\">$res[position_1_t]</option>";}else{$command.="";}if(!$res[position_2_t]==""){$command.="<option name=\"position\" value=\"$res[position_2_t]\">$res[position_2_t]</option>";}else{$command.="";}if(!$res[position_3_t]==""){$command.="<option name=\"position\" value=\"$res[position_3_t]\">$res[position_3_t]</option>";}else{command.="";}if(!$res[position_4_t]==""){$command.="<option name=\"position\" value=\"$res[position_4_t]\">$res[position_4_t]</option>";}else{$command.="";}if(!$res[position_5_t]==""){$command.="<option name=\"position\" value=\"$res[position_5_t]\">$res[position_5_t]</option>";}else{$command.="";}$output.="</select>";[/code]The problem is on submit, the values aren't being sent into the database. I know the values are being read correctly because "$res[name]" in the dropdown shows up, its just that it's not being submitted in.I think it may have something to do with the name of the form, I'm not certain though, a second pair of eyes would be extremely appreciated. Quote Link to comment Share on other sites More sharing options...
Jessica Posted January 31, 2007 Share Posted January 31, 2007 There is no insert query, so... Quote Link to comment Share on other sites More sharing options...
elis Posted January 31, 2007 Author Share Posted January 31, 2007 I assure you, there is an insert query... I did forget to post it. [quote]$send = "INSERT INTO appl_user (tid,pid,username,name,date,loc,posistion,exp,sam_w,sam_s,coms,email) VALUES ('','$uidded','$username','$name','$date','$loc','$posistion','$exp','$samw','$sams','$coms','$email')"; $sent = mysql_query($send) or die("Query setup failed".mysql_error());[/quote]Nor is this "solved". I'd appreciate being asked whether it is instead of assumptions being made in the future. Quote Link to comment Share on other sites More sharing options...
Jessica Posted January 31, 2007 Share Posted January 31, 2007 So we were supposed to imagine the code? Does it die with an error? What is the error?Where is this mystical insert code? It could be the code surrounding it, if it's in an if(), etx. Quote Link to comment Share on other sites More sharing options...
elis Posted January 31, 2007 Author Share Posted January 31, 2007 You immature haughty attitiude is not needed, what part of "I forgot to add the code" are you not comprehending? Do me a favor and just stop replying, I'll look for help else where. Quote Link to comment Share on other sites More sharing options...
Jessica Posted January 31, 2007 Share Posted January 31, 2007 I asked you three very relevant questions, and you didn't answer them. Good luck getting help. Quote Link to comment Share on other sites More sharing options...
elis Posted January 31, 2007 Author Share Posted January 31, 2007 Thank you, Apparently your very mystical relevant questions were useless, as I suspected and stated in my imaginary post, I was missing an id field in the html. 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.