php - Echo out the sum of a MYSQL column -


pretty simple script here working. echoing entire mysql query except sum total of donations. want echo out total donations 1 user, not donations.

here script.

<?php require_once("models/config.php");    $id=$_server['query_string'];  $sql = "select persons.personid, persons.firstname, persons.surname, donations.amount,     sum(donations.amount), donations.donation_type, donations.donation_date, donations.event persons, donations persons.personid = donations.personid = '$id' order personid";  $results = $mysqli->query($sql);   echo "<table border='1' cellpadding='10'>";     echo "<tr> <th>first name</th> <th>surname</th> <th>donation type</th> <th>donation     amount</th> <th>donation event</th> <th>donation date</th></tr>"; if($results->num_rows) { while($row = $results->fetch_object()) { echo "<tr>";             echo '<td>' . $row->firstname . '</td>';             echo '<td>' . $row->surname . '</td>';            echo '<td>' . $row->donation_type . '</td>';            echo '<td>' . $row->event . '</td>';            echo '<td>  $'.$row->amount. '</td>';            echo '<td>' . $row->donation_date . '</td>';   echo "</tr>";   echo "</table>";     echo $row->sum(amount); } } else { echo "</table>";   echo 'no results'; }  ?>

i error code: "fatal error: call undefined method stdclass::sum() in ..." trouble - mysql query, php echo? need query total (something don't want do)?

thanks in advance.

in query give name column 

sum(donations.amount) sum_amount

then print echo $row->sum_amount


Comments

Post a Comment

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

i using signpost oauth access data magento server. have read various tutorials on same , reach point open browser user can enter credentials. however, per requirement have automate part. hence, user should not browser page. have set-up done on server side ( magento ), hit url , returned call page. same through program in android. i have tried below, consumer = new commonshttpoauthconsumer(key, secret); provider = new commonshttpoauthprovider(oauth_init_url,access_token_url, authorize_url); try { provider.retrieverequesttoken(consumer, oauth.out_of_band); log.d("tokens" , consumer.gettoken() + " -- " + consumer.gettokensecret()); } and request tokens. dont know how bypass next step. tried directly accessing accesstoken (stupid of me) provider.retrieveaccesstoken(consumer, "mycallback://callback"); no luck, ends in oauth.signpost.exception.oauthnotauthorizedexception: authorization failed (server replied 401). ...
Read more

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

getting error org.mockito.exceptions.misusing.invaliduseofmatchersexception: invalid use of argument matchers! 1 matchers expected, 2 recorded. exception may occur if matchers combined raw values: //incorrect: somemethod(anyobject(), "raw string"); when using matchers, arguments have provided matchers. example: //correct: somemethod(anyobject(), eq("string matcher")); at when( getprogramservice .callservice(any(getprogramtype.class))) .thenreturn(jaxbresponse); please explain error , possible resolution the code posted looks fine; don't see problem it. code before or above causing exception. key here: invalid use of argument matchers! 1 matchers expected, 2 recorded. any , used above, doesn't return "special kind of null" or "special kind of getprogramtype"; don't exist. instead, returns null , side effect puts matcher on stack. whe...
Read more

google shop client API returns 400 bad request error while adding an item -

i'm working on solution add items in google shopping market java application. following tutorial real mess because of missing classes of laste release, after setting 1.5-beta maven managed make base example typecheck correctly classes. still can make simple task of adding 1 item. instead of posting whole code i'm posting part creates product feed. private product createproduct(string id) { product product = new product(); product.title = "red wool sweater"; product.content = new content( "text", "comfortable , soft, sweater keep warm on " + "cold winter nights. red , blue stripes."); product.appcontrol = new appcontrol(); product.appcontrol.addrequireddestination("productads"); product.externalid = id; product.lang = "it"; product.country = "it"; product.condition = "nuovo"; product.price = new price("eu...
Read more