php variables stopping mysql working

aerecords

hey all i am building a system which never leaves the page index.php.

Instead it uses index.php?p=(module name)&s=(page to be placed in the content area).

My issue is when ever i try to put any content which connects to mysql i get the following error

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/andreffx/public_html/mods/admin/newconf.php on line 34

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/andreffx/public_html/mods/admin/newconf.php on line 36.

The thing that confuses me is that if i go straight to the file in bold above it works but not when accessing it througth the url variable.

Any help would be greatley apreciated.

To see the error for yourself the root is
http://andrews-enterprise.co.uk/

and the only uploaded mod is at
http://andrews-enterprise.co.uk/index.php?p=admin&s=newconf

If needed i can upload the problem in a zip file obviousley without the database logins being correct for security.

NogDog

The "not a valid link" suggests to me that the database connection is failing (or is not being done at all). I would suggest that you start the debugging by checking any calls to mysql_connect() to see if they are returning false, and if so perhaps logging or outputting some debug info via mysql_error(). If that's not it, then make sure the logic flow has you doing a connect before submitting any queries, and for that matter that you are not doing any mysql_disconnect() before those queries. 😉

bradgrafelman

What does line 34 of newconf.php look like, and where do you define the second parameter you're passing in to [man]mysql_select_db/man on that line?

aerecords

hey nogdog thanks for the quick reply the connections works if my browser points direct to the file but its when it uses the url variable way that i require it to work with.

its the system you helped me with in the past using this forum.

aerecords

bradgrafelman;10995068 wrote:
What does line 34 of newconf.php look like, and where do you define the second parameter you're passing in to [man]mysql_select_db/man on that line?

the line is

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{

And im not 100% sure i use dreamweaver cs5.5

bradgrafelman

aerecords;10995070 wrote:

the line is

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{

No it isn't. The error message clearly states that there was a call to mysql_select_db() on line #34 of newconf.php, so whatever you posted was not from line 34 of newconf.php since there was no such call.

aerecords;10995070 wrote:
And im not 100% sure i use dreamweaver cs5.5

Using Dreamweaver to write PHP code (or any other programming language, really) is probably your first mistake, then. 😉