Re: PHP Newbie- Display Aggregates in HTML Table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Reed Loefgren wrote:

I have a query that returns data that includes a sum(). I can't get this sum to display in an html table. Like so (in part):

Example bit:

psql test: select code, blah, sum(time) from test;

Portion of PHP table code:

while($myrow = pg_fetch_assoc($result)) {
    printf ("<tr><td>%s</td><td>%s</td><td>%s</td></tr>",
      $myrow['code'], $myrow['blah'], $myrow['<what goes here?>']);

To display the result of an function, it's usually best to alias the value, like so: select code, blah, sum(time) AS the_sum from test; That way, you can use $myrow['the_sum'] to access that value. You could also do $myrow['sum(time)'], but it doesn't, imo, look very nice.

The reason why your query doesn't work, is because you're trying to use an agregate function without a group by clause. ...Which would work fine, if you did just SELECT sum(time) FROM test, but not when you do SELECT code, blah, sum(time) FROM test.


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux