Why is this query failing?

Posted on 16th Feb 2014 07:03 pm by admin

Why is this not working?
$query = "SELECT * FROM `users` WHERE `userid` = " . $USERID AND `pin` = " . $PIN;
$result = mysql_query($query)
or die("Web site query failed");

When I all I have is:
$query = "SELECT * FROM `users` WHERE `userid` = " . $USERID;
$result = mysql_query($query)
or die("Web site query failed");

It does work. But when I ad the PIN, it just fails. I have the variable $PIN assigned and I have a field called pin.

Thanks

Your Answer:

Login to answer

Other forums

Where do I put CRON code
So I've figured out alot about how to automatically run a php function. I can't figure out where to

RSS poster script?
I have found a script that posts RSS's for me on a site that I'm building. However I would like to a

need help in update query
i create a form for update. there are 8 columns in my mysql table. on my main page all the data is r

utf8_general_ci error ??
I have all kinds of data to be inserted in database table

//I am getting this error

Yo

please help
HTML Code:

Code: <span id="ctl00"><span>

I need some help with the IF command...
I have a large number of images in one section of my website with the .jpg format. I'm adding a bun

Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,

ALV List display - header width adjust
Hi,

I am using REUSE_ALV_LIST_DISPLAY for my ALV display.The width of the ALV varies for

Basic Question Regarding PHP Includes
Hi

Just starting out with PHP.

Working on a site that uses some basic includes, these

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q