[RESOLVED] DB Query problem

fasterisbest

Hello,

Can anyone tell me why this query may not be working? I keep getting the "I can not run query." from the if statement.

Here is my code:

//set variable query 
		$query = "	SELECT count (*)
					FROM tblAuth
					WHERE 	userName 	= '$userName' and 
							password	= '$pass'";
//query db 		
		$result = mysql_query($query);

		if(!$result)
			{
			echo 'I can not run query.';
			exit;
			}

Thanks for all your help.

laserlight

Do some debugging (and formatting of code), e.g.,

//set variable query
$query = "SELECT count(*)
          FROM tblAuth
          WHERE userName = '$userName'
          AND password = '$pass'";
//query db
$result = mysql_query($query);

if(!$result)
{
    exit('I can not run query: ' . mysql_error());
}

alimadzi

Print the query to the screen too and make sure your variables are set properly.

fasterisbest

Thanks very much for your time.

I am not exactly sure where the error was coming from but the problem is fixed.

It may have been the AND statement.

Thanks again.

fasterisbest

How do i mark this as resolved?

bpat1434

I've done it for you. But for future reference, it's Thread Tools --> "Mark Thread Resolved"

abc123

Click "Thread Tools" -> "Mark Thread As Resolved" at the top of your post