SUM of Column problem

[[deleted]]

Hi All,
I want to have the total of a column with numers, but i am getting some errors.

$sql = "SELECT * FROM regents";
 	$result2 = mysql_query($sql) or die(mysql_error());
 	while ($row = mysql_fetch_object($result2)) {

// calculate income goldbars
echo "regent id: $row->regent_id<br>";
$result3 = mysql_query ("SELECT * SUM(prov_poplvl) AS Total FROM provinces WHERE prov_regentid=$row->regent_id");
$row3 = mysql_fetch_array($result3);
echo "$row3->Total";

heres there error
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

anyone?

[shu]

//Your query was NOT successfully executed, try enclosing the value with braces ({ })
$result3 = mysql_query ("SELECT * SUM(prov_poplvl) AS Total FROM provinces WHERE prov_regentid={$row->regent_id}");

//PS: It's a good practice to check the status your of query before doing anything with it

[[deleted]]

nope still not working.

heres the whole script

$link = mysql_connect("localhost", "username", "password"); 
$result = mysql_query($link);
@mysql_select_db("legacy");

//update turns

$sql2 = "UPDATE regents SET regent_turns=regent_turns+1";
$result2 = mysql_query($sql2);


$sql = "SELECT * FROM regents";
$result4 = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_object($result4)) {

// calculate income goldbars
echo "regent id: $row->regent_id<br>";

$result3 = mysql_query ("SELECT * SUM(prov_poplvl) AS Total FROM provinces WHERE prov_regentid=($row->regent_id)"); 

$row3 = mysql_fetch_array($result3);
echo "$row3->Total";
}

results of script:

regent id: 1

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\scheduler.php on line 22

regent id: 2

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\scheduler.php on line 22

[shu]

//What's with the
$result = mysql_query($link);
//I never seen that before, and you probably want to execute your queries like:
$sql2 = "UPDATE regents SET regent_turns=regent_turns+1";
$result2 = mysql_query($sql2, $link);

[[deleted]]

that isnt the problem, the problem sits somewhere in the

$result3 = mysql_query ("SELECT * SUM(prov_poplvl) AS Total FROM provinces WHERE prov_regentid=($row->regent_id)"); 

$row3 = mysql_fetch_array($result3);
echo "$row3->Total";

i have tried many ways to write this up, but none worked.
every time i get the Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

[[deleted]]

I finaly got it to work after rewriting it completely

$provincome = mysql_query("SELECT SUM(prov_poplvl) AS prov_poplvl FROM provinces WHERE prov_regentid ='$row->regent_id'");
$resprovincome = mysql_fetch_array($provincome); 
$provcounts = $resprovincome["prov_poplvl"]; 
echo "income prov - $provcounts<br>";

thnx