Sum

[user4fun]

$query = "SELECT SUM(Ad_Max_Pts) FROM tblAd WHERE FK_BusID ='$ses_ID'"; $result = mysql_query($query) or die(mysql_error());

How do i show the result of the $query statment??echo ----------??Thank you

[jeffman]

$result is a resource. It points to data, but isn't data itself. So it can't be echoed or iterated through like an array.The function described here is one way of getting the data $result points to. Look at the example. Notice how the function is used in a loop to extract data from multiple rows. (A loop is not necessary when you can guarantee that only one row will be returned, or when you only want one row at a time.)http://www.php.net/manual/en/function.mysql-fetch-assoc.php

[Ingolme]

You can use the SQL 'AS' operator to assign the result to an element:

$query = "SELECT SUM(Ad_Max_Pts) AS addition FROM tblAd WHERE FK_BusID ='$ses_ID'";$result = mysql_query($query) or die(mysql_error());$res = mysql_fetch_assoc($result);echo $res['addition'];

[jeffman]

Ah. That's what I get for not looking at the whole question.

[user4fun]

Perfect, thank you for much for the help.