not valid MySQL result resource

Anon

The following code gives two error messages: not valid MySQL result resource.

What's wrong?

$result = mysql_query("SELECT SUM(Amortering) AS total FROM Skatteuppg WHERE (Year>=$fromdate AND Year <=$todate )");

list ($total) = (mysql_fetch_row($result));

Anon

try echoing your select statement and then applying the statement directly to the database command line.

claire

Thanks Martin
I've tried the select statement and it works fine. I found out that the there's no database connection. That's way I' m getting the error respons. Trying to figure out why the database connection is failing.

I have a function that I call whenever I need to do a dbsearch:

function initdb($db) {
global $hostname, $mysqluser, $mysqlpassword;
mysql_pconnect($hostname,$mysqluser,$mysqlpassword) or die("Unable to connect to SQL server");
mysql_select_db($db) or die("Unable to select database");

}

Calling initdb($nameofdb); usually works fine, not just here?

rbenfield

hmmm, since both of the functions used within your initdb function say " or die(message)", I dont think either of them is failing. If they failed it would not get to your select statement. Rather it would stop and display the error message for which ever one was the problem. The problem must be somewhere else. You only mentioned one of the two error messages you are getting, what is the other? can you post the rest of the code?

Thanks,
Richard

claire

Hi Richard

you were right! I found that when I tried the script on its own, sending vars from a form I made up for the purpose of testing - all worked fine.

When I included the snippet into an existing more complex document getting vars from an already existing form it didn't work.

I found out that the vars from my test form didn't have the same name as the vars in the real form. Correcting the names of the vars in the script did the trick!!!

Sloppy me!

Thanks a lot!

claire

I'm sending vars from a form:
<FORM METHOD = "post" ACTION="docalc.php">
Here is a SELECT made....and a WHILE ...{....
and eventually listing as many forms as there are entries in the db:

$i=1;
<INPUT TYPE = "TEXT" NAME = "<? echo "fromdate$i" ?>" VALUE = "<? echo "$indate";?> "
<INPUT TYPE = "TEXT" NAME = "<? echo "todate$i" ?>" VALUE = "<? echo ($year -1);?>"

$i++ ;

}
?>
<INPUT TYPE="SUBMIT" VALUE="send">

The docalc.php should act on the vars $fromdate and $todate,

$result = mysql_query ("SELECT SUM(Amortering) AS total FROM Skatteuppg WHERE (År>=$fromdate$i AND År <=$todate$i )");
list ($total) = mysql_fetch_row($result);

but it doesn't work the way I have named them in the form.

rbenfield

unless I am mistaken, you can not have a variable name for a variable. Therefore the way to do what you want to do is not to name the variable $todate$i but rather to make $todate and array of variables with an index number of $i. In which case the code should look like this...

$i=1;
<INPUT TYPE = "TEXT" NAME = "<? echo "fromdate[$i]" ?>" VALUE = "<? echo "$indate";?> "
<INPUT TYPE = "TEXT" NAME = "<? echo "todate[$i]" ?>" VALUE = "<? echo ($year -1);?>"

$i++ ;

}
?>
<INPUT TYPE="SUBMIT" VALUE="send">

The docalc.php should act on the vars $fromdate and $todate,

$result = mysql_query ("SELECT SUM(Amortering) AS total FROM Skatteuppg WHERE (År>=$fromdate[$i] AND År <=$todate[$i] )");
list ($total) = mysql_fetch_row($result);

Hope that helps,
Richard