php Programming Glossary: friendid
MYSQL select mutual friends http://stackoverflow.com/questions/8906154/mysql-select-mutual-friends SELECT CASE WHEN userID id THEN userID2 ELSE userID END AS friendID FROM friends WHERE userID id OR userID2 id I have tried this.. id OR userID session THEN userID2 ELSE userID END AS friendID FROM friends WHERE userID session OR userID2 session AND userID.. session OR userID2 session AND userID id OR userID2 id AND friendID session also it shouldn't return the row if friendID session..
|