Reed Loefgren wrote:
All,
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.
Tommy
