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. Link to comment https://forums.phpfreaks.com/topic/36441-solved-option-form-isnt-sending-to-mysql/ Share on other sites More sharing options...
Jessica Posted January 31, 2007 Share Posted January 31, 2007 There is no insert query, so... Link to comment https://forums.phpfreaks.com/topic/36441-solved-option-form-isnt-sending-to-mysql/#findComment-173407 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. Link to comment https://forums.phpfreaks.com/topic/36441-solved-option-form-isnt-sending-to-mysql/#findComment-173412 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. Link to comment https://forums.phpfreaks.com/topic/36441-solved-option-form-isnt-sending-to-mysql/#findComment-173414 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. Link to comment https://forums.phpfreaks.com/topic/36441-solved-option-form-isnt-sending-to-mysql/#findComment-173417 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. Link to comment https://forums.phpfreaks.com/topic/36441-solved-option-form-isnt-sending-to-mysql/#findComment-173422 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. Link to comment https://forums.phpfreaks.com/topic/36441-solved-option-form-isnt-sending-to-mysql/#findComment-173429 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.