Help with error.

[klassicd]

I have tried everything in my mind to get this too work. Im going to see if anyone else can. The problem is is when someone trys to access viewpmsg.php i get this error.....

Warning: Supplied argument is not a valid MySQL-Link resource in /web/sites/178/kfoolio/www.kfoolio.f2s.com/html/functions.php on line 360

Error doing DB query in check_user_pw()


When i go into functions.php i see this:


function check_user_pw($username, $password, $db) {
global $system, $prefix;
if (!$system) {
$password = crypt($password,substr($password,0,2));
} else {
$password = $password;
}
#$password = md5($password);
$username = addslashes($username);
$sql = "SELECT user_id FROM users WHERE (username = '$username') AND (user_password = '$password')";
$resultID = mysql_query($sql, $db); //this is line 360
if (!$resultID) {
echo mysql_error() . "<br>";
die("Error doing DB query in check_user_pw()");
}
return mysql_num_rows($resultID);
} // check_user_pw()

I dont see a thing wrong with it. does anyone have any ideas?

[qslack]

The $db that check_user_pw is getting is not a valid MySQL connection handle/link. Are you sure there were no errors connecting?

Also...if you only have 1 MySQL connection then you don't need to supply the connection handle to the mysql_* functions.

[sylow]

function check_user_pw($username, $password, &$db)

[klassicd]

I know its an error connecting, but i still cant seem to find it. And yes i need to have the $db cause i have multiple connections.

And in reply to sylow i tried that and it didnt help. I was wondering why you even put that. I have never seen it written that way before.

Thanks for your help anyways.

[smashway]

$resultID = mysql_query($sql, $db); //this is line 360

you should modify this with

$resultID = mysql_query($sql, $db) or die(mysql_error());

like this, you'll be able to actually see the potential error messages!

[klassicd]

Its definitly an error connecting to the database. I just cant seem to find out what it is. This is the only function in my script that doesnt seem to work and its set up like the rest. well if i cant solve it i guess i will just have to take it out.

[smashway]

check your $db link identifier. Where is it supposed to be assigned? try to trace it through your code... Check for variables/values speling errors too
That call to mysql_query() looks a bit confusing to me... Are you tryging to connect to different database SERVERS? or just to different databases on the same server? in the latter case you'd better use mysql_db_query(); more info about that function can be found here

Hope it helps,