MySQL PHP query not working correctly

Question

The following code doesn't seem to be working correctly, when I put just 1 thing in WHERE it works fine so maybe I cant do multiple items in here?

The code snippet is

$query_view_users = "SELECT id, type, name, username, email FROM admin_users WHERE id, type, name, username, email LIKE '$search'";

Thank you so much for your help. :-)

John Woo · Accepted Answer · 2012-10-27 16:55:14Z

5

it's a multi-condition WHERE clause. use OR or AND which ever satifies your needs.

SELECT ...
FROM ....
WHERE id   LIKE '$search' OR 
      type LIKE '$search' OR 
      name LIKE '$search' OR 
      username LIKE '$search' OR 
      email    LIKE '$search'

edited Oct 27, 2012 at 16:55

answered Oct 27, 2012 at 16:32

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

2 Comments

janenz00 Over a year ago

OR or AND? Looks like he meant AND. +1'ed

John Woo Over a year ago

@janenz00 yeah, i added both. it depends on what he needs :D

Gabamnml · Accepted Answer · 2012-10-27 16:44:36Z

0

your sql would have to be

$query_view_users = "SELECT * FROM admin_users WHERE id OR type OR name OR username OR email LIKE '$search'";

answered Oct 27, 2012 at 16:44

Gabamnml

1561 silver badge10 bronze badges

Collectives™ on Stack Overflow

MySQL PHP query not working correctly

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related