MySQL using WHERE and OR

Question

I am allowing people to input either their username, account number or email address before typing their password, so i need to compare their input against 3 fields in my table but i am not getting any results.

i first tried this ...

$result = mysqli_query($con,"SELECT * FROM useraccounts WHERE username='$thisuser' or accnum='$thisuser' or email='$thisuser'");

then i read on here that brackets should be placed around OR statements, so tried this ...

$result = mysqli_query($con,"SELECT * FROM useraccounts WHERE (username='$thisuser' or accnum='$thisuser' or email='$thisuser')");

but neither work, can someone help please

just for comparison, this does work when i type in the username value ...

$result = mysqli_query($con,"SELECT * FROM useraccounts WHERE username='$thisuser'");

Please paste the rest the rest of the code. Does $thisuser contain the correct value? Are you sure it exists in the database? — cornelb
– cornelb, Commented Feb 27, 2014 at 12:07
The brackets are not needed there (you use them to force operator precedence, which would be required if you needed to check for a match on any of those fields AND the password). But both those queries look fine from a syntax point of view. — Kickstart
– Kickstart, Commented Feb 27, 2014 at 12:09
@DanFromGermany i think you are try to say setup SQLfiddle right ? — krishna
– krishna, Commented Feb 27, 2014 at 12:14
you should start by quoting your values correctly into the query — NDM
– NDM, Commented Feb 27, 2014 at 12:28

AnonymousCoder · Accepted Answer · 2014-02-27 12:26:19Z

1

What is the datatype of accnum? Are you sure it is varchar?

If accnum is of type numeric then try

$result = mysqli_query($con,"SELECT * FROM useraccounts WHERE (username='$thisuser' or accnum=$thisuser or email='$thisuser')");

answered Feb 27, 2014 at 12:26

AnonymousCoder

5922 gold badges7 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Blackwolf Over a year ago

it is numeric, and i have tried your code but still no joy

AnonymousCoder Over a year ago

Have you tried executing the same query on mysql? and if you have allready tried that can you share some more code here, and make sure that $thisuser is not empty

Blackwolf Over a year ago

yeah $this user has a value, i mentioned this in my original post - however i have made my accnum into a CHAR and it all seems ok now

AnonymousCoder Over a year ago

try printing your query in php like

$qstr="SELECT * FROM useraccounts WHERE (username='$thisuser' or accnum=$thisuser or email='$thisuser')"; print $qstr;  $res=mysqli_query($con,$qstr);

This may give you a hint what is happening.

Andolasoft Inc · Accepted Answer · 2014-02-27 12:15:54Z

0

Seems no problem. Please check '$thisuser' has value. Try printing the sql statement. You may try running query directly on database.

answered Feb 27, 2014 at 12:15

Andolasoft Inc

1,2961 gold badge7 silver badges16 bronze badges

Comments

codemania · Accepted Answer · 2014-02-27 12:33:21Z

0

I also think first check the value of $thisuser, and then try below query

$result = mysqli_query($con,"SELECT * FROM useraccounts WHERE (username='".$thisuser."' or accnum='".$thisuser."' or email='".$thisuser."')");

edited Feb 27, 2014 at 12:33

codemania

1,0901 gold badge9 silver badges26 bronze badges

answered Feb 27, 2014 at 12:25

Supriya Pansare

5791 gold badge4 silver badges11 bronze badges

Comments

Kittu · Accepted Answer · 2014-02-27 12:38:20Z

0

Rathere then using at server side if it done at client side in js file by checking it emailid or username oraccount number according to that u can pass value

answered Feb 27, 2014 at 12:38

Kittu

195 bronze badges

1 Comment

Blackwolf Over a year ago

how can it client check without first accessing the database to make a comparison ?

Collectives™ on Stack Overflow

MySQL using WHERE and OR

4 Answers 4

4 Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related