Problem Adding Variables -

Mero

I have been trying this all day and I am about to scream. Im new to PHP so I may be missing somthing simple.

<---------------------------------------------------------------->

if ( $nrows > 0 ) { print "<TABLE BORDER=\"1\">";

print "<TR>";
print "<TH>Part Number</TH><TH>Part Name</TH><TH>Quantity</TH><TH>Individual Part Cost</TH><TH>Total Part Cost</TH>";
print "</TR>";

$ta = 0;
$tt = 0;

for ( $i = 0; $i < $nrows; $i++ )
{ reset($results); print "<TR>";

while ( $column = each($results) ) 
	{ $data = $column['value']; 
	print "<TD align=right>$data[$i]</TD>"; 
	$ta = $results["TCOST"][$i];
	$tt += $ta;
	}

print "</TR>";}

print "<TR><TD></TD><TD></TD><TD></TD><TD align=right>Grand Total:</TD><TD align=right>$tt</TD>";

print "</TABLE>";}

<--------------------------------------------->

Im trying to get a Grand Total for a cost column but all im getting is 0.

Any Ideas?

LordShryku

I think we may need some more detail here. Are you getting all this from a database? If so, what's the database structure?

Have you tried echoing out all of your $results["TCOST"][$i]? Just to see if they're right...

And use the [ php ][ /php ] tags. You need some serious formatting to your code...

Mero

This is all hooked into an oracle DB, its not want I want to use but I have to in this situation.

I have echoed out all the results they all comeout correct. The problem happens when I try to Add the variables together.

As it is right now the $ta += is returning 0. If I do a $ta = it returns the last value only.

<?
SESSION_START();

//putenv("ORACLE_SID=dbone");
putenv("ORACLE_HOME=/u01/oracle/product/9ir2");
$connect=ocilogon("xxxx", "xxxx", "dbone.linux");

$s_id = session_id();

$sql = "SELECT KC_CAMPUS.CART.ITEM_ID , KC_CAMPUS.ELECTRONIC_PARTS.PART_NAME, KC_CAMPUS.CART.QUANTITY, TO_CHAR(KC_CAMPUS.ELECTRONIC_PARTS.PART_COST, '$999.99'), TO_CHAR(KC_CAMPUS.CART.QUANTITY * KC_CAMPUS.ELECTRONIC_PARTS.PART_COST, '$9,999.99') TCOST FROM KC_CAMPUS.ELECTRONIC_PARTS, KC_CAMPUS.CART WHERE KC_CAMPUS.CART.ITEM_ID = KC_CAMPUS.ELECTRONIC_PARTS.PART_NUMBER AND KC_CAMPUS.CART.COOKIE_ID = '$s_id'";

$stmt = OCIParse($connect, $sql);
OCIExecute($stmt);

$nrows = OCIFetchStatement($stmt,$results);

if ( $nrows > 0 ) { print "<TABLE BORDER=\"1\">";

print "<TR>";
print "<TH>Part Number</TH><TH>Part Name</TH><TH>Quantity</TH><TH>Individual Part Cost</TH><TH>Total Part Cost</TH>";
print "</TR>";

$ta = 0;

for ( $i = 0; $i < $nrows; $i++ )
{ reset($results); print "<TR>";

while ( $column = each($results) ) 
	{ $data = $column['value']; 
	print "<TD align=right>$data[$i]</TD>"; 
	}
	$ta += $results['TCOST'][$i];		
print "</TR>";}

print "<TR><TD></TD><TD></TD><TD></TD><TD align=right>Grand Total:</TD><TD align=right>$ta</TD>";

print "</TABLE>";}

else { echo "There are no Items in your Cart.<BR>";}
OCIFreeStatement($stmt);
?>

LordShryku

try this

//change this code
 while ( $column = each($results) )
{ $data = $column['value'];
print "<TD align=right>$data[$i]</TD>";
}
$ta += $results['TCOST'][$i];

//to

while($column = each($results) ) {
    $data = $column['value'];
    print "<TD align=right>$data[$i]</TD>";
    $ta += $data[4];
}

Based upon your SQL, this should work for you. This will add up the total while in the loop. And that was why you we're only pulling the last record. You weren't in the loop

Mero

Tried that already, in the loop. When I put it in the loop it doesnt even return a 0.

I am stumped.

LordShryku

but did you try it with $data[4] instead of $results['TCOST'][$i]?

Mero

Yeah its wierd. I copied your code and tried just incase 😛

When i do a echo $data[4] it echos correctly, in fact everything works just fine until I try to add them together...

Just to test I tried a $a = 1; $b = 2; $c = $a + $b; inside the loop and it came out correctly.

LordShryku

Well damn....

See if you can do it in the SQL. May need to do a rollup and pull the last value...

SELECT C.ITEM_ID,
EP.PART_NAME,
C.QUANTITY,
TO_CHAR(EP.PART_COST, '$999.99'),
TO_CHAR(C.QUANTITY * EP.PART_COST, '$9,999.99') TCOST
FROM KC_CAMPUS.ELECTRONIC_PARTS EP, KC_CAMPUS.CART C
WHERE C.ITEM_ID = EP.PART_NUMBER
AND C.COOKIE_ID = '$s_id
GROUP BY rollup(C.ITEM_ID)

Something like that....

Mero

Thank You Sir.

After you rewrote my sql with the table aliases I finally figured it out 😛

My sql was changing the values to CHAR so when I was trying to do math on them it didnt work. I thought PHP would do math on chars too but like I said I am new to PHP.

Anywayz the problem was resolved by removing the TO_CHAR from the sql.

Thanks Again.