Showing the total of fields

[stonelord]

I have a field on my table the tracks square footage. At the bottom of the table on my page I'd like to show the total square footage entered, but my code is not working. Here is my code and this is the error I get; Call to undefined function mysql_query_add() in /home/ci/public_html/remakes/remakes_index.php

 

<?php
$result = mysql_query_add('SELECT SquareFeet FROM sqtable');

if (!$result) {
  exit('<p>Error performing query: ' .mysql_error().
  '</p>');
  }
  
echo "<table border='1' bordercolor='#666633' cellpadding='3' cellspacing='0'>";
echo '<tr> <th bgcolor="#999966">Total Square Footage</th></tr>';

while ($row = mysql_fetch_array($result)) {
echo '<tr><td>';
echo $row['SquareFeet'];
echo '</td></tr>';
}

?>

Any suggestions?

[hitman6003]

mysql_query_add is not a function in php.

 

I think you want something like this:

 

SELECT SUM(SquareFeet) AS total_square_feet FROM sqtable

 

Which you would use like so:

 

$result = mysql_query($query);

echo 'Total Square Footage: ' . mysql_result($result, 0, 'total_square_feet');

[iversonm]

come on, i was going to answer that and you posted a reply before i could.. shoot haha but ya what he said

[stonelord]

Thank you very much, it works. But I am trying to understand the "0", what does it do?

$test = mysql_result($result,0,'total_square_feet');

 

[hitman6003]

Selects the first row from the result set...

 

http://www.php.net/mysql_result

[stonelord]

Thanks again!

I just thought of something. (I haven't tried this yet) but is there a way to show this same total (square footage) on my main page? (just the total to trasnfer and also update itself on the main page?). Would you have to rewrite the holw query again on the main page?