[RESOLVED] Easy SQL problem

**the182guy** · Mar 23rd, 2006, 08:41 AM

im trying to search a table based on fname and sname fields

PHP Code:


$sql = "SELECT * FROM members WHERE fname, sname LIKE '%$search%'";

the above gives me a mysql error. but the following works when I search just the fname field

PHP Code:


$sql = "SELECT * FROM members WHERE fname LIKE '%$search%'";

anyone know the SQL syntax for searching more than one field?

**techgnome** · Mar 23rd, 2006, 09:23 AM

Well, in your example. both lines are the same.... probably related to copy/pasting...

What I think you want is this:

Code:

 $sql = "SELECT * FROM members WHERE fname '%$search%' OR sname LIKE '%$search%'";

-tg

**the182guy** · Mar 23rd, 2006, 09:47 AM

PHP Code:


$sql = "SELECT * FROM members WHERE fname '%$search%' OR sname LIKE '%$search%'";

errors

ive tried playing around with it

**the182guy** · Mar 23rd, 2006, 09:53 AM

i know it is the SQL query that is causing the error because

SELECT * FROM members

works with no error, only when i try to search two fields

**the182guy** · Mar 23rd, 2006, 09:54 AM

ok got it working now

PHP Code:


$sql = "SELECT * FROM members WHERE fname LIKE '%$search%' OR sname LIKE '%$search%'";

**techgnome** · Mar 23rd, 2006, 10:02 AM

hehehe.... sorry about that... I felt off the LIKE on the first one didn't I?

-tg

Thread: [RESOLVED] Easy SQL problem