[Forse]

Hello folks. I am sorry for weird description in topic, but I dunno how else to describe it. I have an include file (navigation menu) where I must establish connection to local mysql server and get couple of rows...everything works fine when file is included on normal pages, but when I include it in my forum code (which is invision power board 1.3) I get this message:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /configure/config.php on line 540

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /configure/config.php on line 541

Here is my connect code which is nothing unusual:

Code:

$db = mysql_pconnect($varz['settings']['mysql']['host'], $varz['settings']['mysql']['user'], $varz['settings']['mysql']['pass']) or report_msql_error(mysql_error,true);
mysql_select_db($varz['settings']['mysql']['database'],$db) or report_msql_error(mysql_error,true);

Forums and website use same database and same username/login. I use persistent connection coz I server is dedicated to that site and it's mysql driven so it reduces the load a little. I also tried using different login/password (2 accounts for website and one for forums), but it's no go. It seems as php can't connect to mysql if code I am trying to run is in forums.

This must be confusing, sorry. But it's been pain in you know where. I have read mysql docs, googled and searched many forums...still nothing.

Any help is welcome, I thank you in advance!

[georgian]

Is the $db getting reinitalized somewhere in the forum code.....

Try echo $db; the line after you make the database connectioin and the line before you need it in the mysql_query....

See if the value are the same.... If there not, that's why you sql querys are working.... To fix it, rename your $db to something different....

Hope this helps..

[Forse]

Originally Posted by georgian

Is the $db getting reinitalized somewhere in the forum code.....

Try echo $db; the line after you make the database connectioin and the line before you need it in the mysql_query....

See if the value are the same.... If there not, that's why you sql querys are working.... To fix it, rename your $db to something different....

Hope this helps..

Tried renaming it...no go But thxn for reply