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

[drranch]

::) 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);

[hvle]

it meant your $connection is bad.  The query is good, but check how you connect to database.

[drranch]

;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