[RESOLVED] Easy SQL problem

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? :thumb:

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

PHP Code:

---

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


---

errors :( ive tried playing around with it

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

ok got it working now

PHP Code:

---

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


---

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

-tg