suming mysql via php

dreams4000

Hi all, I want to be able to do multiple sums via mysql, and then pull that data out to echo in php. I looked on the forum here and found one example that shows pretty much below, but I cant seem to get it to work.. any ideas?

$tmpquery = "select SUM(reg), SUM(reg2), SUM(reg3) from  mytable WHERE  id >= '1' AND id <= '10'";
my_sum($tmpquery);

$sum_reg = $row[0];
$sum_reg2 = $row[1];
$sum_reg3 = $row[2];

Any ideas? Thanks!

planetsim

Is my_sum suppose to be a function you created? Also where is $row array getting defined???

dreams4000

Yes, my_sum is a function.. has a little more than this, but this is the jist of it:

$conn = mysql_connect(MYSERVER,MYLOGIN,MYPASSWORD);
	mysql_select_db(MYDATABASE, $conn);
		$sql = "$tmpcon";
		$result = mysql_query($sql, $conn);

$row = mysql_fetch_row($result); 

    @mysql_free_result($result);
	@mysql_close($conn);

Connecting is not the problem, getting it to pull the right data and show the multiple summed fields is:\

planetsim

Why are you doing this

$sql = "$tmpcon";

Its just a waste of a variable.

Also $row doesnt appear to be returning from the function. Which is why $row outside the function wont contain the same results as in the function.

As for the problem try running the Query in PHPMyAdmin you will probably find out you will need to modify the query.