Trying to add MySQL columns and then display

[$username]

Hello everyone,

 

So I want to add up some columns then display passed on a ID field.

Is there something I am doing wrong?

Here is some code.

 

			
$sql531= mysql_query("SELECT * FROM payments WHERE PaymentAccountID = '$AccShow'");
while($row531 = mysql_fetch_array($sql531)) {
			echo "<tr>";	  
			echo("<td><a href=\"?invoiceid=".$row531["PaymentInvoiceNum"]."\" title=\"".$row531["PaymentInvoiceNum"]."\"> Invoice </a></td>"); 
			$TotalAmount += ($row532['PaymentUnitPrice'] * $row532['PaymentQuantity']);
			echo "<td>$TotalAmount</td>";
			echo "<td></td>";
			echo "<td>".$row531['PaymentCreateDate']."</td>";
			echo "<td>".$row531['PaymentDueDate']."</td>";
			echo "</tr>";
			}

 

 

 

[$username]

I fixed this it was a typo.

 

Thanks,

Brett