Undefined variable: y in C:\wamp\www\gun.php on line 8

[Ruchi choudhary]

I am getting an error that "y is undefined variable".
I know this will gonna be so simple and basic problem but I am new to php so that's why I am facing this problem.
please me its urgent for me.

<?php
$Amtoffirstrelease=$_POST['Amtoffirstrelease'];
$Amtofsecondrelease=$_POST['Amtofsecondrelease'];
$head=$_POST['head'];
$subhead=$_POST['subhead'];
$Availableamt=$Amtoffirstrelease+$Amtofsecondrelease;
$sanctionedamt=$_POST['sanctionedamt'];
$progressivebal=$y+$sanctionedamt;
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "purchase";
mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname) or die(mysql_error());

$x="SELECT MAX(progressivebal) FROM 'naipone'";
$y= mysql_query("SELECT progressivebal FROM 'naipone' WHERE progressivebal=x") or die('error');
$query="insert into naipone(Amtoffirstrelease, Amtofsecondrelease, head, subhead, 

Availableamt,sanctionedamt,progressivebal) values 

('$Amtoffirstrelease','$Amtofsecondrelease','$head','$subhead','$Availableamt','$sanctionedamt','$progressiveba

l')";
mysql_query($query)or die('error');
echo"database update with:" .$Amtoffirstrelease."" .$Amtofsecondrelease. "".$Availableamt."" .$head."".

$subhead."";
?>

[Rabbit]

Line 8, you use a variable y without first assigning it a value.

[Ruchi choudhary]

Now its solved but its show error1 which at 18 line.

[gvuksa]

You should use mysql_error to know exactly what the error is.
You should maybe lose empty lines or try something like this

$query="insert into naipone(Amtoffirstrelease, Amtofsecondrelease, head, subhead," .
 
"Availableamt,sanctionedamt,progressivebal) values" .
 
"('$Amtoffirstrelease','$Amtofsecondrelease','$head','$subhead','$Availableamt','$sanctionedamt','$progressiveba" .
 
"l')";

[Ruchi choudhary]

Thanks!
It works.I solved that problem. But now the main problem is progressivebal values does not update as I want (like line 9 and 18).
Thank you

[Rabbit]

We only allow one question per thread on this forum. Please create a new thread for your question.