[SOLVED] SQL SUM

[gevensen]

im trying to sum the column split_amount from table sc_expenses_transactions

can anyone tell me what im doing wrong?

$sql_query="SELECT SUM( split_amount) FROM sc_expenses_transactions WHERE ( expense_id = '$transaction_id') ";
$result=mysql_query($sql_query);
if(!$result){ die(mysql_error()); }
$query_data=mysql_fetch_array($result);
$number=$query_data[0];
echo "Query = " .$number."<br />";

 

 

[watsmyname]

im trying to sum the column split_amount from table sc_expenses_transactions

can anyone tell me what im doing wrong?

$sql_query="SELECT SUM( split_amount) FROM sc_expenses_transactions WHERE ( expense_id = '$transaction_id') ";
$result=mysql_query($sql_query);
if(!$result){ die(mysql_error()); }
$query_data=mysql_fetch_array($result);
$number=$query_data[0];
echo "Query = " .$number."<br />";

your query got no problem

but why are you using fetch array?? your query just returns one row. use it like $query_data= mysql_result($result, 0, 0);

[gevensen]

it returns Resource id #9

am i not converting it right?

[watsmyname]

it returns Resource id #9

am i not converting it right?

TRY THIS ONE

<?php
$sql_query="SELECT SUM(split_amount) as split_sum FROM sc_expenses_transactions WHERE expense_id = '$transaction_id'";
$result=mysql_query($sql_query);
if(!$result){ die(mysql_error()); }
$query_data= mysql_result($result, 0, "split_sum");
echo "Query = " .$query_data."<br />";
?>

[gevensen]

i guess if i wasnt dumb it would help

 

the query did work fine

 

i didnt assign the $transaction_id a valid number

 

thanks for the help