Problem with Addition and Update

[dapcigar]

Am trying to get a current price, add it to what is in the database and update the table with the new value. Every time i do it, it won't do the addition but update the table with the current price. Please, what am i doing wrong?

$sql2 = mysql_query("SELECT *  FROM pbudget WHERE project_name = '$project' ");
		$budget = mysql_fetch_array($sql2);		
	
						
	$actual = $budget['actual'] ;
	$actual = $budget['spent'] ;
	$tot = ($spent + $amount);
	
	$final = ($actual - $amount);
	
	//$final = ($actual + $amount);			

$r = mysql_query("UPDATE pbudget SET actual = '$final', spent ='$tot'  WHERE project_name = '$project'") or die(mysql_error());



$que = mysql_query("UPDATE budget SET actual = '$final', spent ='$tot'  WHERE category = '$cat'") or die(mysql_error());

[ginerjm]

You have a glaring error in your code.  Where do you set the value of $spent?

[dapcigar]

Yeah you are right. i named it $actual instead of $spent..

 

 

Thanks