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

button.click += new eventhandler() not works in if(!ispostback)
i want to use button.clcik event in function VIewScrap() which is called in if(!ispostback) but itdo

Filtering an Array Based on Value
I have a very simple script set up that pulls data from a database and is output using this code:

Simple Question
I know this is a simple question, that if I knew what it was technically called i could probably loo

form problem
below in the form action, i've put "test.php?w=$sw&h=$sh" but when i input the for

Can I call a class inside a function?
I have a class written in another file that handles my image resizing.

Can I do this (php say

What are the two different files you download to update kernel?
What are the two different files you download to update kernel?

Production of mango in processing industry
Hi,

We have one scenario ,company is in process industry,they are manufacturing MANGO pul

When file included, REMOTE_ADDR is server's?
I have an index file that handles my site, basically index.php?page=ip will activate "require('

Escaped characters
I have a script that allows you to post news to the home page of my site. Along with the news is the

PHP Tab Control
Hi All,

I would like to have PHP tab control with/without Javascript.

But I want to r