Ryan
Ryan

Reputation: 11

Query MySQL from PHP code?

Is their a code were you can use Or in a mysql query?

I used this code to find some Emails from a reciver.

mysql_query("select * from Friends where Reciver like '%$term%'");

but i want to do a code like

mysql_query("select * from Friends where Reciver or Sender like '%$term%'");

my question is? is this right because when I try it it doesn't come up with anything?

If it isn't right could you say so and say why it isn't? i learn well from my mistakes?

Upvotes: 1

Views: 76

Answers (4)

Ibu
Ibu

Reputation: 43810

Here is how you do it

mysql_query("SELECT * FROM Friends WHERE Reciver LIKE '%$term%' OR Sender LIKE '%$term%'");

Upvotes: 4

Ólafur Waage
Ólafur Waage

Reputation: 69991

1st of all. Check out the dangers of SQL Injection.

2nd try this query.

select * from Friends where Reciver LIKE '%$term%' OR Sender LIKE '%$term%'

Upvotes: 8

Harry Joy
Harry Joy

Reputation: 59660

You can do this query and for that your query should be like this:

select * from Friends where Reciver like '%$term%' or Sender like '%$term%'

Upvotes: 2

Emil Vikström
Emil Vikström

Reputation: 91922

select * from Friends where Reciver like '%$term%' or Sender like '%$term%';

Upvotes: 2

Related Questions