Calculating a Total Price

nightmicu

Greetings,

Yes, I have tried searching -- new to MySQL and cannot find any posts that specifically answer this question. So, here it is:

Writing a program for my wife to keep track of items she wishes to purchase for our new home. Right now, it is very basic -- a form adds data to a table, data is then displayed by date, price, category, etc.

I am trying to echo a total price amount of all entires from the price row in the table -- i.e. item 1 is $5, item 2 is $10, TOTAL (printed under all entries) would be $15. I am using a while loop to print each entry onto the page.

Any suggestions?

Thanks!

-Ben

big_nerd

Try something like:


$running_total = $0;

$query = "select * from database";
$result = mysql_query($query);

while ($row = mysql_fetch_object) {
       echo "$row->expence_col - $row->other_col - $row->price_col";
       $running_total = $running_total + $row->price_col;
}
echo "The Total Spent is: ".$running_total;

Something like that?

This should run through every expence and tally it as it displays it.

You could then add a "WHERE" clause to your query to search by date(s) if you have them set.

nightmicu

Here is the code that I am using:

$sql = "SELECT * FROM $table_name ORDER BY date DESC";
$result = mysql_query($sql, $connection);
while ($row = mysql_fetch_array($result)) {
	$name = $row['name'];
	$date = $row['date'];
	$category = $row['category'];
	$price = money_format('%n', $row['price']);
	$url = $row['url'];
	$image = $row['image'];
	$notes = $row['notes'];
#more code here, not relevant -- includes a Display Block for each entry.
}

In the past, I've had no problem keeping a tally of how many entries are in a database with a simple i++ statement, was hoping this would be as easy.

Thanks..

Ben

Installer

Using big.nerd's suggestion is easy, and for total entries, just use mysql_num_rows():

$entries = mysql_num_rows($result);
$running_total = 0;
while ($row = mysql_fetch_array($result)) {
    $running_total += $row['price'];
    // etc.

Or look into MySQL SUM().