Problem assigning value to variable in "IF" function

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

Does this script makes sense? I am trying to take the value that is set to "authenticat" and write it to authentication.

I think it is getting messes up by the $authenticat = "1" part.

Thanks
function check_username_pin($USERID, $PIN)
{
$query="SELECT id FROM users WHERE ( userid = '$USERID' AND pin = '$PIN' )";
// dont return pin because of hackers
$result=mysql_query($query);
if(mysql_num_rows($result)>0)
{
$authenticat = "1"
}
$query="SELECT id FROM users WHERE ( useris = '$USERID' )";
// dont return pin because of hackers
$result=mysql_query($query);
if(mysql_num_rows($result)==0)
{
$authenticat = "2"; // bad id
}
$query="SELECT id FROM users WHERE ( pin = '$PIN' )";
// dont return pin because of hackers
$result=mysql_query($query);
if(mysql_num_rows($result)==0)
{
$authenticat = "3"; //bad pin
}
}

write("SET VARIABLE authentication $authenticat");

Your Answer:

Login to answer

Other forums

Validating time
Hi Guys

what do you think of the following approach to validate a 24hour time:

http://

A problem with my GD class
Hello,

I created a nice (and simple for now) GD class.
The problem is , it works great on

Help building / using array
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query que

Run function every 5 mins ??
I have a function PostMessage()

How can I run it every 5 mins ??

AJAX form submit
I recently built a form that submits data to my database with an ajax function that is called throug

How to show a complete textarea ??
I enter Client Case Notes notes in a textarea field on a PHP form. The field is 5 rows deep and 70 c

All possible combinations of String in PL/SQL
Hi All,

Could you please explain the logic of getting all possible combinations of String

problem in program for counting no of chars using pointers
Hi all, I was trying to make a program which counts number of chars in a string using concpt of poin

email form (cannot find the problem)
Hello there. I've been having trouble with an email form. Can't find the problem really. I've tested

More pug propaganda.
http://www.youtube.com/watch?v=8Kkrmubsgf8

The commercial is definitely worth watching pug aw