Need help with SUM - php

[jnkwebdesignz]

I need help getting the SUM of a few columns on a webpage, below is the link to the page and the complete script.

I need totals for the following columns (Bid, Ask, Website).

Here's the page - http://www.jnkwebdesignz.com/brokems.php?sorter=1959%

Here's the script:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++

<?php
//Database Connection
include_once $_SERVER['DOCUMENT_ROOT'] . '/includes/gs.inc.php';

$sorter = $_REQUEST['sorter'];

// Get a specific result from the "totals" table
$result = mysql_query("SELECT * FROM totals
WHERE date LIKE '$sorter' AND mintproof LIKE 'Mint Set' ORDER BY date ") or die(mysql_error());

// print out the results
if( $result )
{
while( $contact = mysql_fetch_object( $result ) )
{
// print out the info
$id = $contact -> id;
$date = $contact -> date;
$denom = $contact -> denom;
$type = $contact -> type;
$bid = $contact -> bid;
$ask = $contact -> ask;
$auction = $contact -> auction;
$special = $contact -> special;
$website = $contact -> website;
$mintproof = $contact -> mintproof;
$bidtotal = $contact -> bidtotal;

     //Calculate Single Count Ask
if ($denom == 'Cent') {
    $ask = $ask/'50';
    $ask = number_format ($ask, 2);
} elseif ($denom == 'Nickel') {
    $ask = $ask/'40';	
    $ask = number_format ($ask, 2);
} elseif ($denom == 'Dime') {
    $ask = $ask/'50';	
    $ask = number_format ($ask, 2);
} elseif ($denom == 'Quarter') {
    $ask = $ask/'40';	
    $ask = number_format ($ask, 2);
} elseif ($denom == 'Half Dollar') {
    $ask = $ask/'20';	
    $ask = number_format ($ask, 2);
}

//Calculate Single Count Bid
if ($denom == 'Cent') {
    $bid = $bid/'50';
    $bid = number_format ($bid, 2);
} elseif ($denom == 'Nickel') {
    $bid = $bid/'40';	
    $bid = number_format ($bid, 2);
} elseif ($denom == 'Dime') {
    $bid = $bid/'50';	
    $bid = number_format ($bid, 2);
} elseif ($denom == 'Quarter') {
    $bid = $bid/'40';	
    $bid = number_format ($bid, 2);
} elseif ($denom == 'Half Dollar') {
    $bid = $bid/'20';	
    $bid = number_format ($bid, 2);
} 

//Calculate Auction Price
$auction = $bid*'.95';
$auction = number_format ($auction, 2);

//Calculate Special Price
$special = $ask*'1.05';
$special = number_format ($special, 2);

//Calculate the Totals
$bidtotal += $bid;
$bidtotal = number_format ($bidtotal, 2);

//Calculate Website Price
if ($ask >='.01' AND $ask <='.20') {
$website = $ask+'.20';
$website = number_format ($website, 2);
} elseif ($ask >='.21' AND $ask<='.50') {
$website = $ask'1.73';
$website = number_format ($website, 2);
} elseif ($ask >='.51' AND $ask<='1.00') {
$website = $ask'1.6';
$website = number_format ($website, 2);
} elseif ($ask >='1.01' AND $ask<='5.00') {
$website = $ask'1.48';
$website = number_format ($website, 2);
} elseif ($ask >='5.01' AND $ask<='15.00') {
$website = $ask'1.42';
$website = number_format ($website, 2);
} elseif ($ask >='15.01' AND $ask<='25.00') {
$website = $ask'1.33';
$website = number_format ($website, 2);
} elseif ($ask >='25.01' AND $ask<='50.00') {
$website = $ask'1.28';
$website = number_format ($website, 2);
} elseif ($ask >='50.01' AND $ask<='100.00') {
$website = $ask'1.21';
$website = number_format ($website, 2);
} elseif ($ask >='100.01' AND $ask<='10000.00') {
$website = $ask'1.17';
$website = number_format ($website, 2);
}

$result = mysql_query("SELECT date,denom,bid,ask FROM totals WHERE date LIKE '$sorter' AND mintproof LIKE 'Mint Set' ORDER BY date");
if (!$result) {
echo "An error occured.\n";
exit;
}

while ($row = mysql_fetch_array($result))

{
echo "$row[0] &nbsp;&nbsp; $row[1] &nbsp;&nbsp; $row[2] &nbsp;&nbsp; $row[3] &nbsp;&nbsp; $website";
echo "<br />\n";
}

}
}

?>

<?php

$sql = "SELECT SUM(bid) AS sum_bid FROM totals WHERE date LIKE '$sorter' AND mintproof LIKE 'Mint Set' ORDER BY date";
$result = mysql_query($sql) or die(mysql_error());
$i = mysql_fetch_array($result);

echo "<br>";
echo $i['sum_bid'];
?>

[jnkwebdesignz]

Looks like I posted the wrong script, so below is the correct version.

I basically need to use my data, do the calculations to the pricing (bid, ask) come up with the new totals (website). Then display the new results, then total the sum of the results (bid, ask, website) at the bottom of the page in some fashion.

The page design can change e.g. get rid of the tables, I just did it this way for looks.

Here's the correct script:
+++++++++++++++++++++++++++++++++++++++++++++++++++++++

<?php
// Header
include("header.php");
?>

<center><table border='1' width="90%" bgcolor="C5DFF2">
<tr align="center">
<td width='30'>
<b>ID</b></td>
<td width='100'>
<b>Date</b>
</td><td width='100'>
<b>Denomination</b>
</td><td width='100'>
<b>Type</b>
</td><td width='90'>
<b>Bid</b>
</td><td width='90'>
<b>Ask</b>
</td><td width='90'>
<b>Auction</b>
</td><td width='90'>
<b>Special</b>
</td><td width='90'>
<b>Website</b>
</td></tr>
</table></center>

<?php
//Database Connection
include_once $_SERVER['DOCUMENT_ROOT'] . '/includes/gs.inc.php';

$sorter = $_REQUEST['sorter'];

// Get a specific result from the "totals" table
$result = mysql_query("SELECT * FROM totals
WHERE date LIKE '$sorter' AND mintproof LIKE 'Mint Set' ORDER BY date ") or die(mysql_error());

// print out the results
if( $result )
{
while( $contact = mysql_fetch_object( $result ) )
{
// print out the info
$id = $contact -> id;
$date = $contact -> date;
$denom = $contact -> denom;
$type = $contact -> type;
$bid = $contact -> bid;
$ask = $contact -> ask;
$auction = $contact -> auction;
$special = $contact -> special;
$website = $contact -> website;
$mintproof = $contact -> mintproof;
$bidtotal = $contact -> bidtotal;

//Calculate Single Count Ask
if ($denom == 'Cent') {
$ask = $ask/'50';
$ask = number_format ($ask, 2);
} elseif ($denom == 'Nickel') {
$ask = $ask/'40';
$ask = number_format ($ask, 2);
} elseif ($denom == 'Dime') {
$ask = $ask/'50';
$ask = number_format ($ask, 2);
} elseif ($denom == 'Quarter') {
$ask = $ask/'40';
$ask = number_format ($ask, 2);
} elseif ($denom == 'Half Dollar') {
$ask = $ask/'20';
$ask = number_format ($ask, 2);
}

//Calculate Single Count Bid
if ($denom == 'Cent') {
    $bid = $bid/'50';
    $bid = number_format ($bid, 2);
} elseif ($denom == 'Nickel') {
    $bid = $bid/'40';	
    $bid = number_format ($bid, 2);
} elseif ($denom == 'Dime') {
    $bid = $bid/'50';	
    $bid = number_format ($bid, 2);
} elseif ($denom == 'Quarter') {
    $bid = $bid/'40';	
    $bid = number_format ($bid, 2);
} elseif ($denom == 'Half Dollar') {
    $bid = $bid/'20';	
    $bid = number_format ($bid, 2);
} 

//Calculate Auction Price
$auction = $bid*'.98';
$auction = number_format ($auction, 2);

//Calculate Special Price
if ($ask >='.01' AND $ask <='.20') {
    $special = $ask+'.07';
    $special = number_format ($special, 2);
} elseif ($ask >='.21' AND $ask<='.50') {
    $special = $ask*'1.30';
    $special = number_format ($special, 2);
} elseif ($ask >='.51' AND $ask<='1.00') {
    $special = $ask*'1.25';
    $special = number_format ($special, 2);
} elseif ($ask >='1.01' AND $ask<='5.00') {
    $special = $ask*'1.17';
    $special = number_format ($special, 2);
} elseif ($ask >='5.01' AND $ask<='15.00') {
    $special = $ask*'1.15';
    $special = number_format ($special, 2);
} elseif ($ask >='15.01' AND $ask<='25.00') {
    $special = $ask*'1.11';
    $special = number_format ($special, 2);
} elseif ($ask >='25.01' AND $ask<='50.00') {
    $special = $ask*'1.09';
    $special = number_format ($special, 2);
} elseif ($ask >='50.01' AND $ask<='100.00') {
    $special = $ask*'1.08';
    $special = number_format ($special, 2);
} elseif ($ask >='100.01' AND $ask<='10000.00') {
    $special = $ask*'1.08';
    $special = number_format ($special, 2);
}

//Calculate Website Price
if ($ask >='.01' AND $ask <='.20') {
$website = $ask+'.20';
$website = number_format ($website, 2);
} elseif ($ask >='.21' AND $ask<='.50') {
$website = $ask'1.73';
$website = number_format ($website, 2);
} elseif ($ask >='.51' AND $ask<='1.00') {
$website = $ask'1.6';
$website = number_format ($website, 2);
} elseif ($ask >='1.01' AND $ask<='5.00') {
$website = $ask'1.48';
$website = number_format ($website, 2);
} elseif ($ask >='5.01' AND $ask<='15.00') {
$website = $ask'1.42';
$website = number_format ($website, 2);
} elseif ($ask >='15.01' AND $ask<='25.00') {
$website = $ask'1.33';
$website = number_format ($website, 2);
} elseif ($ask >='25.01' AND $ask<='50.00') {
$website = $ask'1.28';
$website = number_format ($website, 2);
} elseif ($ask >='50.01' AND $ask<='100.00') {
$website = $ask'1.21';
$website = number_format ($website, 2);
} elseif ($ask >='100.01' AND $ask<='10000.00') {
$website = $ask'1.17';
$website = number_format ($website, 2);
}

     echo "<table border='1' align='center' width='90%'>";
     echo "<tr align='center'>";
     echo "<td width='30'>";
     echo "<a href='greysheet/edititem.php?id=$id'>$id</a>";
     echo "<td width='100'>";
     echo "$date";
     echo "</td><td width='100'>";
     echo "$denom";
     echo "</td><td width='100'>";
     echo "$type";
     echo "</td><td width='90'>";
     echo "$bid<br>";
     echo "</td><td width='90'>";
     echo "$ask<br>";
     echo "</td><td width='90'>";
     echo "$auction<br>";
     echo "</td><td width='90'>";
     echo "$special<br>";
     echo "</td><td width='90'>";
     echo "$website<br>";
     echo "</td></tr>";
     echo "</table>";         

     }

}
else
{
die( "Trouble getting contacts from database: " . mysql_error() );
}

?>

<?php
// Get Mint Set Info

// get the id from the URL request
$denom = $_REQUEST['denom'];

if( $id )
{

  // retrieve the row from the database
  $query = ("SELECT * FROM totals
   WHERE date LIKE '$sorter' AND denom LIKE 'Mint Set'") or die(mysql_error());

  $result = mysql_query( $query );

  if( $result && $contact = mysql_fetch_object( $result ) )
  {
     // set our variables
     $date = $contact -> date;
     $denom = $contact -> denom;
     $type = $contact -> type;
     $bid = $contact -> bid;
     $ask = $contact -> ask;

  }
  }  

?>

<form action="greysheet/saveitem.php" method="get"> <input type="hidden" name="id" value="<?php echo($id) ?>">
<table border="1" cellpadding="3" cellspacing="3" align="center" width="90%" bgcolor="C5DFF2">
<tr><th align="left">Date</th><td align="left"><input name="date" type="text" value="<?php echo($date) ?>" /></td>
<th align="left">Denomination</th><td align="left"><input name="denom" type="text" value="<?php echo($denom) ?>" /></td>
<th align="left">Type</th><td align="left"><input name="type" type="text" value="<?php echo($type) ?>" /></td>
<th align="left">Bid</th><td align="left"><input name="bid" type="text" value="<?php echo($bid) ?>" /></td>
<th align="left">Ask</th><td align="left"><input name="ask" type="text" value="<?php echo($ask) ?>" /></td></tr>
</table>

</form>