[nassau]

i'm making a database driven website and everything works perfect. but, every once in a while, i'm unable to connect to MySQL from my own script. out of the blue it just will not connect. however, PHP My Admin will always connect without problems.

does anyone have a clue why i'm having this problem, and how to fix it? my solution has always been to haggle for a few hours and reinstall MySQL etc which is a pain.

[ben.periton]

What is the code you are using to connect?

[nassau]

PHP Code:

// database query START

// ··························



function global_DbQuery($selection, $input, $extra1, $extra2, $extra3){



// Calling values from outside the function

global $text_Db_ErrorConnection, $text_Db_ErrorDatabaseSelection, $text_Db_ErrorDbQueryNotSelected, $text_Db_ErrorDbQueryNotAvailable, $global_PathIncludesSite;





// filter submitted "extra" values

$extra1 = global_QuoteValue($extra1);

$extra2 = global_QuoteValue($extra2);

$extra3 = global_QuoteValue($extra3);



// INSERT, SELECT, DELETE queries only

if ($selection <= 999){

// put each value from array on a single line, add commas

foreach ($input as $key => $input2){$value .= global_QuoteValue($input2); if ($key < (count($input) -1)){$value .= ', ';}}

}



// UPDATE queries only

elseif (($selection >1000) and ($selection <=1999)){

// keep array as is, set $value = $input

$value = $input;

}



// include database info and custom database queries for website

include $global_PathIncludesSite.'dbInterface.php';



// Connecting to, and selecting database

$db_connection = mysql_connect($db_Server, $db_Username, $db_Password)

or die($text_Db_ErrorConnection . mysql_error());

mysql_select_db($db_Database) or die($text_Db_ErrorDatabaseSelection);



// Querying database

$result = mysql_query($query);



// Return result of query

return $result;

}



// ··························

// database query END 

this is what is actually failing

mysql_select_db($db_Database) or die($text_Db_ErrorDatabaseSelection);

so, it's not able to select the database for some reason.

[nassau]

and it's not just my script that isn't working. other scripts i got from online don't work. but PHP My Admin always works.





also, i found this is PHP My Admin:

Error
The additional features for working with linked tables have been deactivated.

PMA Database ... not OK[ Documentation ]
General relation features Disabled

and i can't really figure out what it is..

[UnrealEd]

try this:

PHP Code:

$db_connection = mysql_connect($db_Server, $db_Username, $db_Password)

or die($text_Db_ErrorConnection . mysql_error());

mysql_select_db($db_Database, $db_connection) or die($text_Db_ErrorDatabaseSelection); 

don't know if it's gonna help, but you might give it a try

Greetz,
UnrealEd

[nassau]

interesting idea, i'll try that and see if it saves me the next time, hoping there won't be a next time.

thanks!

[Jon_Ptavis]

I'm new to mysql but I noticed the same thing. I went into the 'mysql Admin\useradministration\"user" \ resource' here you will find three setting max_questions: max_updates: max_connection: increase these to a number that will allow you to test you code. Once your done and ready to co to production lower the numbers.
I hope this helps