Jump to content

Archived

This topic is now archived and is closed to further replies.

drranch

Need Help with, 'not a valid MySQL-Link resource'

Recommended Posts

::) I need another pair of eyes, since I can't see what is wrong with this statement...

[b]Error message:[/b]
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in D:\inetpub\vhosts\test.com\httpdocs\authenticate.inc on line 15

[b]Here is the code:[/b]
  // Formulate the SQL find the user
  $query = mysql_query("SELECT password FROM users WHERE username = '{$loginUsername}'
            AND password = '{$password_digest}' AND activated >'0'", $connection);

Share this post


Link to post
Share on other sites
it meant your $connection is bad.  The query is good, but check how you connect to database.

Share this post


Link to post
Share on other sites
;D  Found it....

The order of my function authenticateUser data was set incorrectly.

[b]Original call function design:[/b]
function authenticateUser($loginUsername, $loginPassword, $connection)

[b]On page processing data:[/b]
>:( bad function; bad >:(
authenticateUser($connection, $_SESSION["loginUsername"], $oldPassword))

[b]corrected bad function:[/b]
authenticateUser($_SESSION["loginUsername"], $oldPassword, $connection))

thanks for pointing me in the right direction ;D

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.