[SOLVED] MySQL Update Query problem

[psychowolvesbane]

$a = $_GET['EditThisItemType'];

[adam291086]

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

[psychowolvesbane]

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!!!

[adam291086]

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

[psychowolvesbane]

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!