cds — Mon, 05 Mar 2001 15:44:31 +0000

You can stop beating your face on your desk. I think the World has enough Bulldogs.

Although, if you feel it is necessary and want to feel like you have accomplished something at the same time, I would recommend chasing parked cars.

beating face on desk

Mark Hensler — Mon, 05 Mar 2001 07:21:03 +0000

sorry I missed that..

cds — Sun, 04 Mar 2001 16:35:06 +0000

Thanks Mark,

Got me started in the right direction anyway. As was listed above, it would only return the first $sprice in $total.

After consulting the PHP manual "again", it occurred to me that with the 'if' statement, it really wasn't creating a loop. Changing the 'if' to 'while' fixed the problem and life is good and I like computers again.

Mark Hensler — Sat, 03 Mar 2001 17:48:16 +0000

just add all the sprices, right?

<?php
$total = 0;
$sum = mysql_query ("select sprice from sell_quote where orderid = '$cartid' and complete = -1");
if ($row1 = mysql_fetch_array($sum)){
$sprice = $row1["sprice"];
$total += $sprice;
}
?>

*beating face on desk*

beating face on desk