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?
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%'
Here is how you do it
mysql_query("SELECT * FROM Friends WHERE Reciver LIKE '%$term%' OR Sender LIKE '%$term%'");
select * from Friends where Reciver like '%$term%' or Sender like '%$term%';
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%'
