Multiple queries - HELP!

[philosophology]

I have a function that does calls on 2 other functions that execute queries and send back the result. The problem is that the result is not printed on the screen! What am I doing wrong?

function fn1(){

echo "vars: ".get_sum_of_vars(); //<<<<<< DOES NOT SHOW ANYTHING

get_vars(); //<<<<<< DOES NOT SHOW ANYTHING

}

function get_sum_of_vars() {
    $con = dbconnect();
    $query ="SELECT * FROM tbl2 WHERE var1='1'";
    $result=mysql_query($query);

$totalVars == 0;

while (list($var1,$var2)) = mysql_fetch_row($result)) {
    $totalVars = $totalVars + $var1;
}
return $totalVars ;

}

function get_vars() {    

    $con = dbconnect();
    $query ="SELECT * FROM tbl2 WHERE Var1='1'";
    $result=mysql_query($query);

while (list($variable1,$variable2)) = mysql_fetch_row($result)) {
    echo "$variable1,$variable2";
}

}

[dagon]

do you call the function fn1() ?

[philosophology]

dagon;10922435 wrote:

do you call the function fn1() ?

Yes, I do. I have also tried putting one of the functions inside fn1() , and it works, but not if I put both of them! So I took them out because

1- it is easier to have smaller functions that do distinct chores
2- it helps me fix things faster

Is it possibly because I have the same connection and query twice?

[dagon]

is dbconnect a global var?

[philosophology]

Actually I figured it out! in my version of the code instead of '1' I had a variable that I was not passing through to the function! THANKS!

[Weedpacket]

If you're posting for some help with some code you're having trouble with, it helps to post the code you're having trouble with. (In other words, when you're cutting down the amount of code you're posting to narrow down where the error lies, you should make sure the code you're posting actually shows the problem that you're having and that you're not cutting out the error in the process.)

Don't forget to mark this thread resolved.