Totaling Numbers PHP

[SN3]

How can I total colums in PHP from a database? Just a little script I can add into a current PHP script.

[littleFella]

It might be a bit silly to do that in PHP, although there may be circumstances under which you'd opt for PHP rather than for SQL.
Why don't you try SQL first:

SELECT SUM(FieldName) FROM TableName

[jeet]

Adding columns? Do you mean rows?
I thought columns were made in the table structure...
Are you making columns on the fly with ALTER TABLE command?
Bye

[littleFella]

Originally Posted by jeet

Adding columns? Do you mean rows?

Who's adding columns?

Originally Posted by jeet

I thought columns were made in the table structure...

You thought correctly, but you have no idea about basic SQL syntax.

[jeet]

Originally Posted by littleFella

Who's adding columns?

You thought correctly, but you have no idea about basic SQL syntax.

I'm confused... Didn't the thread starter say, "How can I total colums"?
And the thread title says "totaling numbers"?

Thanks for your nice words anyway...
Bye

[daboss]

Originally Posted by jeet

I'm confused... Didn't the thread starter say, "How can I total colums"?
And the thread title says "totaling numbers"?

Thanks for your nice words anyway...
Bye

he sure had nice words for you didn't he?

anyway, yup doing it using an sql statement is much easier. but if you insist of doing it using php, you'll have to:
1. query the table
2. store the results in a recordset
3. iterate every record in the recordset and sum up the values

try the codelet below (i have not tested it - coded it right out of my head):

$sql = "select column from table where [your criteria here]";
$rst = mysql_query($sql);

while($row = mysql_fetch_array($rst)) :
  $total = $total + $row['column'];
endwhile;

print "Total = " . $total;

[jeet]

Originally Posted by daboss

he sure had nice words for you didn't he?
anyway, yup doing it using an sql statement is much easier. but if you insist of doing it using php, you'll have to:
1. query the table
2. store the results in a recordset
3. iterate every record in the recordset and sum up the values
try the codelet below (i have not tested it - coded it right out of my head):

$sql = "select column from table where [your criteria here]";
$rst = mysql_query($sql);
while($row = mysql_fetch_array($rst)) :
  $total = $total + $row['column'];
endwhile;
print "Total = " . $total;

Oh, I get it now...
He wanted to total the "values" stored in a "column".
Hope I am right this time...
Bye

[SN3]

Hmm...It does not seem to be working. The column name is "total" and the table is listings. Why isn't it working:

<?
$sql = "listings";
$rst = mysql_query($sql);

while($row = mysql_fetch_array($rst)) : <----line 87
$total = $total + $row['total'];
endwhile;

print "Total = " . $total;
?>

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [file location] on line 87
Total =

[littleFella]

out of curiosity; what's stopping you from doing this in just one SQL statement?

[SN3]

What's the PHP code for that?

[littleFella]

PHP Code:

<?php

$query_sum = "SELECT SUM(FiledName) FROM TableName ";
while($row = mysql_fetch_array($query_sum)) 
print "Total = " . $row;

?>

[SN3]

I'm getting:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in xxx line 86.

Line 86:
<?php

$query_sum = "SELECT SUM(total) FROM listings ";
while($row = mysql_fetch_array($query_sum)) <<<Line 86
print "Total = " . $row;

?>

[SN3]

Updated code; still same error:

PHP Code:

<?php
$sql_querysum = 'SELECT SUM(total) FROM listings';
while($row = mysql_fetch_array($sql_querysum)) 
print $row

?>

[SN3]

Anyone?

[Taltos]

SN3, you do need to change your code just a bit. Try this:

PHP Code:

<?php
$sql_querysum = 'SELECT SUM(total) FROM listings';
$sum_results = mysql_query($sql_querysum);
while($row = mysql_fetch_array($sum_results)) 
print $row

?>

[jeet]

If the above code does not work, try this one:

<?php
$sql= "SELECT total FROM listings";
$q = mysql_query($sql);
$l=0;
while($row = mysql_fetch_array($q)):
$l= $row['total'];
$l=$l+$l;
endwhile;
echo $l;
?>
Bye

[Izzmo]

lol.. Sorry to be a party buster, but hasn't the question been answered like 3 or 4 times already?? lol

[jeet]

None of the codes worked...
Bye

Originally Posted by Izzmo

lol.. Sorry to be a party buster, but hasn't the question been answered like 3 or 4 times already?? lol

[SN3]

Originally Posted by jeet

If the above code does not work, try this one:

<?php
$sql= "SELECT total FROM listings";
$q = mysql_query($sql);
$l=0;
while($row = mysql_fetch_array($q)):
$l= $row['total'];
$l=$l+$l;
endwhile;
echo $l;
?>
Bye

That worked. Thanks!