Using 'Update' with Radio Buttons

[imad_imike]

Hi, I'm trying to use the update feature to allow users of my website to change information they have entered.

Heres my form, radio buttons and submit button.

	<form name="Form1" method="post" action="FixedAssetReview_ac.php?id=<? echo $id; ?>">
			 <label><input name="EntryBalanceSheet" id="Intangible" type="radio" value="1"
	                 <? if ($viewOnly == true)
			{
			?>
	                	disabled="true"
	                <?
					}
					?>
					 <?
	                 if ($entryBalanceSheet == 1)
					 {
					 ?> 
	                 checked="checked"
	                 <?
					 }
					 ?>
	                />
	            Intangible</label><label>
	             <input name="EntryBalanceSheet" id="Tangible" type="radio" value="2"
	                 <? if ($viewOnly == true)
				 	{
					?>
	                	disabled="true"
	                <?
					}
					?>
					 <?
	                 if ($entryBalanceSheet == 2)
					 {
					 ?> 
	                 checked="checked"
	                 <?
					 }
					 ?>
	                />
	            Tangible</label>
	</font>
	<input type="submit" name="Submit" value="Submit"></input></form>

So when I click the submit button, it loads up FixedAssetReview_ac.php as it should, heres what this looks like.

$id = isset($_GET['id']) ? (int) $_GET['id'] : 0;

$sql="UPDATE Entry SET EntryBalanceSheet='$EntryBalanceSheet' WHERE EntryID=$id";
$result=mysql_query($sql);

if($result){
echo "Successfully Edited";
echo "<BR>";
echo "<a href='FixedAssetRegister.php'>View result</a>";
}

else {
echo "ERROR";
}

It loads this up correctly and gives me the sucessful message, but it changes the value to 0.
Let me explain better, the row which im trying to change in my database table is called 'EntryBalanceSheet', this row holds numeric values, 1 = Intangible and 2 = Tangible.
When I click on an entry in the database and try change it, it always changes the value to '0' but still gives the sucessful message.

I apoligize about the messy coding and I appreciate any help.

[Derokorian]

$EntryBalanceSheet Where is this defined in the script receiving the form? If it is not defined (which you would see if error_reporting was set to E_ALL) then it will input a 0!

[johanafm]

If that is indeed your entire script, then $EntryBalanceSheet is undefined which produces an error. Set error_reporting to E_ALL or -1 and turn on error logging with log_errors, and optionally display_errors as well (but not in production environment, only development / testing).

[NotSoWhiteNite]

If you run the PHP server, put this at the top of your PHP bracket:
ini_set('error_reporting', -1);
or:
ini_set('display_errors', 1);
This will display all errors.
You can also use E_ALL.

It seems like you're using old PHP, you probably got this idea from an old tutorial.
Nowadays you have to use $POST[''] or $GET[''].
Otherwise you must store your $var into a $SESSION[''] var, then carry it over to the next script.
So,
$SESSION['one'] = $var;
then after the jump,
$var = $_SESSION['one'];

But I would not recommend that method if you can help it. It's awfully messy.