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

Edit MySQL Row Using PHP and HTML Form
Hello,

Here's what I'm trying to do. Build a page where a user enters a MySQL row number in.

Find only certain URLs from page ... regex (semi-complete script)
Hi guys,

What I need to do is take a page & extract all the URLs from the page &a

tag inside php...
hi


Code: <?php
echo "<td width="$columnWidth%" align=&

Save data in input fields when they press "BACK BUTTON"
Hi, this is html form: And let's say they get a error "Please enter ur title must be more then

Login page problems
I developed a website a few months ago and I am now having an issue with logging into it. The place

Multi Dimensional Array Append
Hi Guys

I have a function that returns a multidimentional array eg

$result = functio

how to transport the Query and insfoset
Hi

I have created the query using SQ01........
How to created T-code for query..

Cant display mysql data
Hey all,

I am learning php and my first goal is to create a simple CMS. At the moment I am st

[newb] Image hosting help.
Hey there, I'm new to php, I know some basics and i can code PWN, I'm only 14 but I'm interested in

Custom CMS
This is a big custom CMS script I'd like to develop and would like some help atleast figuring out wh