sum of table to get value

[DrTrans]

Property

Amount

 

Test

100

Test

300

Test

500

 

 

I want to be able to add up all fields of  Amount By Property so it gives me a value of ex. 900.

 

my code

$query9 = "SELECT SUM(Amount) FROM gldetail Where Property_ID = '$prop'"; 
		$result9 = mysql_query($query9);
        echo"$result9";
		$sum = mysql_fetch_assoc($result9);
            $sum2 = $sum['Amount'];
$sum3 =  number_format($sum2,2);

 

Thanks for your help.

 

[Ken2k7]

Change $query9 = "SELECT SUM(Amount) FROM gldetail Where Property_ID = '$prop'"

 

To $query9 = "SELECT SUM(Amount) as amount FROM gldetail Where Property_ID = '$prop'"

 

Then change $sum2 = $sum['Amount'];

 

To $sum2 = $sum['amount'];

[DrTrans]

I keep getting a value of "0" i dont know why there are tons of amounts in my database some of them with "-" next to the first number, so amount could be -357.00" could this be why im getting a "0"

[Ken2k7]

Is the column set to type int?

[DrTrans]

Negative. its set to "float"

[Ken2k7]

After $query9:

 

echo $query9;

 

Copy and paste that here please.

[DrTrans]

 

 

Resource ID: #3 is the responce.

[Ken2k7]

o.O ... what? Paste your updated code here please.

[DrTrans]

$connect = mysql_connect("localhost","root","");
        mysql_select_db("tenantpro");
        $rentid ="6";
$query9 = "SELECT SUM(Amount) as amount FROM gldetail WHERE Property_ID = '$prop'"; 
echo "$query9";
		$result9 = mysql_query($query9);
		echo "$result9";

    	$sum = mysql_fetch_assoc($result9);
             $sum2 = $sum['amount'];

[PFMaBiSmAd]

You already have an existing thread for this problem, where someone already suggested echoing the query statement and executing that query directly against your database.

 

For the code you have shown, echoing the $query9 variable cannot give the result you just posted. What is your real code?

 

And the answer to your problem is that either your query is failing due to an error in the query or with the database server or your WHERE clause in the query is matching no rows.

[Ken2k7]

Remove the echo "$result9"; line please and paste what my echo $query9; outputs to the screen.

[DrTrans]

 

 

$prop = $_GET['prop'];
$connect = mysql_connect("localhost","root","");
        mysql_select_db("tenantpro");
        $rentid ="6";
$query9 = "SELECT SUM(Amount) as amount FROM gldetail WHERE Property_ID = '$prop'"; 
echo $query9; 
		$result9 = mysql_query($query9);


    	$sum = mysql_fetch_assoc($result9);
             $sum2 = $sum['amount'];

 

Responce:

SELECT SUM(Amount) as amount FROM gldetail WHERE Property_ID = '435'

 

 

[Ken2k7]

From the table, looks like it should add up to 0. :-\

[DrTrans]

thats only partial. though

 

 

[Ken2k7]

And when you echo $sum2; you get 0?