psychowolvesbane Posted January 2, 2008 Author Share Posted January 2, 2008 $a = $_GET['EditThisItemType']; Quote Link to comment https://forums.phpfreaks.com/topic/83879-solved-mysql-update-query-problem/page/3/#findComment-428250 Share on other sites More sharing options...
adam291086 Posted January 2, 2008 Share Posted January 2, 2008 well there is no $_GET so change to call on the session $a = $_SESSION['Type'] edit Now post all your current code any any errors Quote Link to comment https://forums.phpfreaks.com/topic/83879-solved-mysql-update-query-problem/page/3/#findComment-428252 Share on other sites More sharing options...
psychowolvesbane Posted January 2, 2008 Author Share Posted January 2, 2008 EUREKA! I got it! Thanks to you I got the sudden idea to put the $a = into an If statement that worked one variable setting when the page loads and a separate one after Submit was pressed: <?php session_start(); //get current type selected if($_POST['SubmitB'] != "Submit") { $a = $_GET['EditThisItemType']; } else { $a = $_SESSION['Type']; } // store session data $_SESSION['Type']=$a; echo $_SESSION['Type']; echo "<br>"; echo $a; echo "<br>"; $Submit = $_POST['SubmitB']; $ItemType = $_POST['ItemType']; The code now works and the update works perfectly too!!! Quote Link to comment https://forums.phpfreaks.com/topic/83879-solved-mysql-update-query-problem/page/3/#findComment-428262 Share on other sites More sharing options...
adam291086 Posted January 2, 2008 Share Posted January 2, 2008 Thank god for that. That one problem with forums. You as the helper don't know how the entire site is working and your logic. All we can help do is debug. You should read up on sessions though Quote Link to comment https://forums.phpfreaks.com/topic/83879-solved-mysql-update-query-problem/page/3/#findComment-428265 Share on other sites More sharing options...
psychowolvesbane Posted January 2, 2008 Author Share Posted January 2, 2008 Oh that's nothing I got to do the same thing but with a bigger form and more inputs! I've gotten a Delete, Add and Edit feature working with the Item Type pages, now I need to do an Add and Edit for the Products, which I'm sure I'll be needing help on soon enough. Thanks for your help! Quote Link to comment https://forums.phpfreaks.com/topic/83879-solved-mysql-update-query-problem/page/3/#findComment-428268 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.