RE: [PHP] Where clause

[snip] I have a table with 2 fields: id_from and id_to. I want to interogate the database and to display the results if the id_to is equal to some current id OR id_from id_from is equla to saame current id. I use this but doesn't work $sql = "SELECT id_from, id_to FROM ids WHERE id_from ='$current_id' OR id_to='$current_id' "; $result = mysql_query($sql); [/snip] This looks OK, but you may want to add parentheses $sql = "SELECT id_from, id_to FROM ids WHERE (id_from ='$current_id' OR id_to='$current_id') ";