Simple query, getting an error [using a function]

sdouble

I am trying to write an authentication function and it doesn't seem to be working very well.

Here is the code I am using

function auth ($txtUser, $txtPass) {
$link = mysql_connect($dbhost, $dbuser, $dbpass);
$row = mysql_query("Select * from sc_auth.users where username = '$txtUser'", $link);
$result = mysql_fetch_array($row);
return $result[username];
};

What is wrong with my code?

I am assuming there is a problem with the $row = mysql_query("Select * from sc_auth.users where username = '$txtUser'", $link);

Thanks a lot for the help. =D

tasistro

$dbhost, $dbuser and $dbpass might not be defined

TRY>

$link = mysql_connect($dbhost, $dbuser, $dbpass) or die('UNABLE TO CONNECT');

If you get UNABLE TO CONNECT, bingo!!!

sdouble

Yeah, it connects. Those are defined in the code before that. I have a file with that and a bunch of functions. This is the only function I'm having problems with. I'm really at a loss. =/

Thanks for replying!

tasistro

Other two options are

change single quotes around $txtUser to double quotes (will have to escape them).

check if permissions allow select from table

sc_auth

sdouble

Alright, I figured it out. You were right. =P

I didn't define the db info in the function, I've fixed it by creating another function with the correct information.


function auth ($txtUser, $txtPass) {
$row = mysql_query("Select * from sc_auth.users where username = '$txtUser'", dblink());
$result = mysql_fetch_array($row);
return $result[pass];
}

Thanks again for the help! =]