Advertisement
Guest User

Untitled

a guest
Feb 18th, 2013
28
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.56 KB | None | 0 0
  1. $query = $conn->prepare('SELECT * FROM '.$tb['feed'].' WHERE '.$feed['user'].' IN
  2.                         (SELECT * FROM '.$tb['conre'].' WHERE '.$cr['to'].' = :u_id OR '.$cr['from'].' = :u_id AND '.$cr['state'].' = :state)
  3.                         OR '.$feed['about'].' IN
  4.                         (SELECT * FROM '.$tb['conre'].' WHERE '.$cr['to'].' = :u_id OR '.$cr['from'].' = :u_id AND '.$cr['state'].' = :state)
  5.                         OR '.$feed['user'].' = :u_id OR '.$feed['about'].' = :u_id
  6.                         ORDER BY datetime DESC LIMIT 20');
  7. $query->execute(array(
  8.     ':u_id' => $user_id,
  9.     ':state' => $state
  10. ));
  11. $result = $query->fetchAll();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement