displaying column sums

[Anon]

i am using the following to add up a several columns, how do i display the resluts ??

$result = mysql_query("SELECT SUM(clk.clicks), SUM(imp.hits) FROM banclk clk, banimp imp");

thanks

[brandonschnell]

$result = mysql_query("SELECT SUM(clk.clicks) as click_total, SUM(imp.hits) as hit_totals FROM banclk clk, banimp imp");

$totals = mysql_fetch_object($result);

echo "Total # of Clicks: ",$totals->click_totals,"<BR>\n";
echo "Total # of Hits: ",$totals->hit_totals,"<BR>\n";

[Anon]

I'm not sure what you mean by displaying the results.

do you mean this:
$row = mysql_fetch_row($result);
print $row[0]; //getting the clicks sum
print $row[1]; // getting the hits sum

or you could do
$result = mysql_query("SELECT SUM(clk.clicks) as total_clicks, SUM(imp.hits) as total_hits FROM banclk clk, banimp imp");
$row = mysql_fetch_array($result);
print $row["total_clicks"];
print $row["total_hits"];

if you wanted to use mysql_fetch_array w/ keys on aliased columns.

p.

[Anon]

thanks guys, once i used 'as' to name the result everything worked fine either way,

although, i had to query each table separtely, trying to do both at the same time basically did the sum twice in each database ? doubling what the result should have been ???