Why isnt this Working

[Haktar]

i dont know why this isnt working, can someone please help, it is returning, $commandername, $totalmembers, and it is echoing the UserName but it isnt returning totalaction.

while ($r = mysql_fetch_array($result)){ 

$commandername=mysql_result(mysql_query("SELECT username FROM users WHERE id='$r[leader]'"),0);
$totalmembers=mysql_num_rows(mysql_query("SELECT id FROM users WHERE federation='$r[id]'"));

$totalpower=mysql_query("SELECT * FROM users WHERE federation='$r[id]'");
while ($a = mysql_fetch_array($totalpower)){
$totalaction = $totalaction + $a['totalaction'];
echo $a['username'];
}

Thanks

[thorpe]

Could be any number of reasons, the code is terrible. Why are you running 3 queries where esentually you only need 1 maybe 2?

What exactly are you wanting to achieve here?

[Haktar]

im trying to get the total power for each member in a federation

[thorpe]

What does your table scheme look like?

[Haktar]

im sorry im not sure what you mean by that as you said before the code it terrible, im prettty new but its best to learn buy doing i guess, i have two tables being used by this code, i assue $totalpower is an array, is ther any other way to go through each value other than a while statment

[laserlight]

Basically, what are the tables and their columns, and how are the tables related?

[Haktar]

ah, in the users table it holds all the information about a user, strike action, and alot more including total action and the Federation ID, and in the Federation table it includes all the info of a Federation like its ID and Name

[Haktar]

ufh lol, it has been working the whole time i was just making a stupid mistake, do you have any idea how i could improve the code