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

Custom list order
Hi there,

I have checked this tutorial and it's great till the point where I want to display

Custom Container in module pool program
Hello everyone,

I have created a custom control in my module pool screen. Now I want to s

Question about the upload of large files
Hi there,

I have a question about the upload of large files, like videos (files generally abo

Session
I am having a little trouble with a session. Not sure if it is my browser or what. I know I do not

uploading video files into mysql in php
hi,
I have the video files which i have to upload into mysql db. along with creating thumbnails f

xml element exists
Code: [Select]<?xml version="1.0"?>
<Addresses>
<

Comparing two dates
Hi Guys
I have two dates I want to compare. Below is my current implementation. The problem with

To add a field on the screen XK02.
Hi All,

How to add an additional field in the vendor change control screen XK02.
The

Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.

Passing vars to the DB
I have 3 small testing tables:

ID TYPE
1 pepperoni
2 C. bacon
3 taco

ID TY